Comment faire un NOT IN dans Qlikview ?

0
310

Hi James,

Try to use this where statement:

WHERE not wildmatch(FieldName, ‘value’, ‘value2’, ‘value3’)

value, value2, value3 should be data you want to exclude.

You can either use wildmatch or mixmatch function.

wildmatch –> ‘valu*’  (wildmatch search)

mixmatch –> ‘value’ (exact data value search)

Hope it helps.

LEAVE A REPLY

Please enter your comment!
Please enter your name here