Not Equals To identifier

Thu, 23 Feb 2012 09:55:02 GMT

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

Not Equals To identifier

Thu, 23 Feb 2012 10:10:55 GMT

Try...

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

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

Dave

Not Equals To identifier

Thu, 23 Feb 2012 10:25:39 GMT

Thanks that worked

topic Not Equals To identifier in QlikView

Not Equals To identifier

Not Equals To identifier

Not Equals To identifier