Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
harsh1994
Contributor
Contributor

Issue in Max function

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)

1 Solution

Accepted Solutions
sunny_talwar

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.

View solution in original post

2 Replies
sunny_talwar

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.

View solution in original post

harsh1994
Contributor
Contributor
Author

Hi Sunny

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