10 Replies Latest reply: Sep 11, 2017 3:42 AM by Joao Bernardo RSS

    Searching in Set Analysis

    Joao Bernardo

      Hey Guys (First time poster here)

       

      I'm very new to sense, and I've been following an ancient book (QlikSense CookBook), and they give this expression as a measure:

       

      sum({<Year={">=$(=MAX(Year)-1)<=$(=MAX(Year))"}>}Sales)

       

      But the returned values in the chart include more years than the 2 selected...

       

      Am I doing something wrong?

      Is there a simpler way to do this?

       

      Thanks in advance