3 Replies Latest reply: Feb 3, 2017 3:40 AM by Dominic Mander RSS

    set modifier problem using ">x<=y"

    Dominic Mander

      I'm using set analyis to select a range of numbers in a column.

       

      e.g. with the data:

      dimensionmeasure
      11
      21
      31
      41
      51

       

      sum(measure) = 5

      sum({$<dimension={">2"}>}measure) = 3

      sum({$<dimension={">2<=4"}>}measure) = 2

       

      ... so far so good ...

       

      I am finding that sum({$<dimension={">5<=5"}>}measure) returns 5, not 0, which doesn't make any sense to me logically.

       

      sum({$<dimension={">5"}*{"<=5"}>}measure) returns 0 as expected.


      Before considering this bug territory I wanted to check whether anyone has encountered this before? Am I missing something obvious here?


      I see the same behaviour in both Qlik Sense and Qlik View

       

      Cheers,

       

      Dominic