Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
MuraliPrasath
Creator III
Creator III

Default Max Date selection in Filter pane when app opens

When I open my app, I wanted to see my max date selection in my Date field. Some one can help me on this.

Capture.PNG

Labels (1)
1 Solution

Accepted Solutions
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @MuraliPrasath

Did you create a new filter pane? Because that is not what you should do. Paste =Num(Date)=Num(Max(ALL Date)) into your filter pane's search box and press Enter.

Filterpane.png

It will select your max date. That is what you then save as a bookmark.

Regards,

Mauritz

View solution in original post

9 Replies
Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @MuraliPrasath 

  1. Paste the following in your filter pane: =Num(Date)=Num(Max(ALL Date))
  2. Save it as a bookmark.
  3. Right click on the bookmark and click on Set selections as app default.

Hope this helps.

Regards,

Mauritz

MuraliPrasath
Creator III
Creator III
Author

Hi,

Thanks for helping me out!

I did try this one, but the below result I'm getting. I wanted to see my date list plus max date selection by default, when I open my app. Thanks. 

Capture.PNG

Mauritz_SA
Partner - Specialist
Partner - Specialist

Hi @MuraliPrasath

Did you create a new filter pane? Because that is not what you should do. Paste =Num(Date)=Num(Max(ALL Date)) into your filter pane's search box and press Enter.

Filterpane.png

It will select your max date. That is what you then save as a bookmark.

Regards,

Mauritz

poojapalni1
Contributor II
Contributor II

Thanks for hint. 

What i did is, i wrote formula in bookmark settings and its working.

 

ioannagr
Creator III
Creator III

@Mauritz_SA hello, maybe you could give me some insight on why this doesn't work on my timestamp filter?

=Num([timestamp])=Num(Max(ALL [timestamp]-maketime(08)))

CITIPK57092
Contributor
Contributor

In my case, its not picking max date, its picking all availble dates

I have added this formula - =Num(DATA_DATE)=Num(Max(DATA_DATE))

CITIPK57092_3-1691155743417.png

 

CITIPK57092_4-1691155793730.png

 

Any idea what's wrong here ?

thanks in advance!

firoz24
Creator
Creator

Hi @MuraliPrasath 

I want to get last date entered with respect to a field

I have a field called station and there are ten fields.

SO I am making 10 sheet seperate and need to get last date with respect to a station 

For eg:- Num(max)=num(max(all date)),[Station]={'Back door glass'}

firoz24
Creator
Creator

Hi @Mauritz_SA 

I want to get last date entered with respect to a field

I have a field called station and there are ten fields.

SO I am making 10 sheet seperate and need to get last date with respect to a station 

For eg:- Num(max)=num(max(all date)),[Station]={'Back door glass'}

Please check this 

firoz24
Creator
Creator

Hi @CITIPK57092 

Did you find any solution for this 

Still I have not solved this issue.