Not Like in Qlikview

[#1]

Guys,

I have a field with the name "Purchase Order ID", I need to exclude the values which contain "A".

Not WildMatch doesnt work properly

[jpenuliar]

<> "A"

[#3]

Where not [Purchase Order ID] ='A'

[Colin-Albert]

Test for wildmatch(fieldname, '*A*') = 0 or for wildmatch(fieldname, '*A*') >0 to test for "not like" or "like" respectively.

You can also use index()

where index(fieldname, 'A') = 0      will only select data that does not contain A in fieldname.

[buzzy996]

tab:

BUCKET:

LOAD * INLINE [

        porid,amt

   a,10

   b,20

   c,30

];

=If(porid <>'a',sum(amt))  --on ur expresion