Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Static Date

Hello All

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.

Please suggest.

Thanks!!

1 Solution

Accepted Solutions
sunny_talwar

Use set analysis to ignore all selections

Max({1} date)

View solution in original post

4 Replies
sunny_talwar

Use set analysis to ignore all selections

Max({1} date)

rupamjyotidas
Specialist
Specialist

Scirpt:

Let vMax= MAX(date);

Show the Variable in UI

rupamjyotidas
Specialist
Specialist

Or Rather

Temp: 

Load 

               Min(DateField) as minDate, 

              Max(DateField) as maxDate 

Resident FWRSData; 

 

Let varMinDate = Num(Peek('minDate', 0, 'Temp')); 

Let varMaxDate = Num(Peek('maxDate', 0, 'Temp'));

Show the Variable in UI

Anonymous
Not applicable
Author

Thanks Sunny for help.

Can you please help me in the below query

Subfield Function

Thanks again