2 Replies Latest reply: Feb 23, 2012 5:25 AM by Margaret Gemmell RSS

    Not Equals To identifier

      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