Not Equals To identifier

[#1]

Hi

I'm trying to write an expression, which only counts records where certain conditions are not met, e.g. Count Internal ID where the School is not equal to 'AA' or 'BB'. We have a long list of School Codes and it would be easier to exclude those we don't want, rather than include the ones we do want, I tried the following but neither work:

count({$<[School Code] <> {'AA', 'BB'}>} [Internal ID])

count({${<[School Code] != {'AA', 'BB'}>} [Internal ID])

Is there a symbol for 'not equals to' that Qlikview recognises? If not, is there another way the above could be achieved?

Thanks

Margaret

[#2 · Accepted solution]

Try...

count({$<[School Code] -= {'AA', 'BB'}>} [Internal ID])

The syntax checker may not like it but it should work.

Dave

[#3]

Thanks that worked