Searching in Set Analysis

[joao_ben]

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

[joao_ben]

Thank you so much. Everything was correct, but apparently there was an option that was activated that enabled showing null values... When i disabled it everything was all right!!