Discussion board where members can get started with Qlik Sense.
Please help me in the below query.
I have the data from 2013 to 2016... In the visualization I need to show the max date.
I am using the formula as MAX(date)..
The issue is that if I select any month on the sheet it will change and shows that particular month max date.
I want that it will always show the max date of the data.. No matter what the filter we apply.
Go to Solution.
Use set analysis to ignore all selections
Let vMax= MAX(date);
Show the Variable in UI
Min(DateField) as minDate,
Max(DateField) as maxDate
Let varMinDate = Num(Peek('minDate', 0, 'Temp'));
Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));
Thanks Sunny for help.
Can you please help me in the below query