topic Re: Issue in Max function in QlikView

Issue in Max function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Issue in Max function

sunny_talwar — Thu, 28 Jun 2018 16:26:54 GMT

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.

Re: Issue in Max function

Anonymous — Fri, 29 Jun 2018 05:48:59 GMT

Hi Sunny

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