Skip to main content
Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
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 (3)
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

6 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!