Issue in Max function

[Anonymous]

Hello everyone,

I want to create a chart in which I have to show the data for the last four years. So for this action, I have used an expression for it like this:

Sum({<Year={'>=$(=max(Year)-3)<=$(=GetFieldSelections(Year))'}, Day= >} AMOUNT)

It works correctly. But I want to know one thing that the max(Year) function values always remain same or it changes with the change in the GetFieldSelections(Year) value.

In Year field, values are 2014 to 2018. So the value of max(Year) function will always 2018 or it will change with GetFieldSelections(Year) value.

Thanks in advance,

Harsh

(Qlikview Learner & Developer)

[sunny_talwar · Accepted solution]

Max() function will change based on selection in Year field... if you select 2012, max(Year) will be 2012... unless you use set analysis to ignore selection.

[Anonymous]

Hi Sunny

Thanks for your reply. Now I will able to use max(Year) function at the right place.