SET EXPRESSION WITH NOT EQUAL

[upaliwije]

I have written the following expression and  is working fine

SUM({$<CODE={'XY','RY'}>}AMOUNT-COMM)

But I want to write the same expression with CODE<>{'XY','RY'}  but not working. Pls help

[don_qlikview · Accepted solution]

If you want to exclude Codes XY & RY then you can try doing this

SUM({$<CODE -= {'XY','RY'}>}AMOUNT-COMM)

[paul_scotchford]

try

SUM({$<CODE={'<>XY and <> RY' }>}AMOUNT-COMM)

[upaliwije]

Thanks