Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
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.
Hi Sunny
Thanks for your reply. Now I will able to use max(Year) function at the right place.