How do you use is not and is not in condition

[#1]

In SQL, you have the following conditions is not ('ABC') and is not in ('ABC', 'XYZ') which are very useful - can you use the same in Qlikview? As I have a list of 80 items and I want to exclude only 2, do I need to include all 78 which seems very cumbersome.

Please let me know.

Thanks.

Ron

[CELAMBARASAN]

You can do it in qlikview like

Load

     *

From Source

Where not Match(FieldName, 'ABC', 'XYZ');

[jpapador]

Or if you want it in an IF Statement it would look like

If(Match(Field1, 'BadValue1', 'BadValue2') > 0, Null(), Field1) as NewField,

[rajni_batra]

if(wildmatch(Field1, 'Value 1' , 'Value 2' )=0,'No','Yes')