Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
deepanshu_chamo1
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
Not applicable

Re: Static Date

Use set analysis to ignore all selections

Max({1} date)

4 Replies
sunny_talwar
Not applicable

Re: Static Date

Use set analysis to ignore all selections

Max({1} date)

rupamjyotidas
Not applicable

Re: Static Date

Scirpt:

Let vMax= MAX(date);

Show the Variable in UI

rupamjyotidas
Not applicable

Re: Static Date

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

deepanshu_chamo1
Not applicable

Re: Static Date

Thanks Sunny for help.

Can you please help me in the below query

Subfield Function

Thanks again