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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Dynamic default filter

Hi experts,

I´ve my filter panel, but each moth change, and I want to set as default with the new period.

The actual is CICLO 2010, the next month wil be CICLO 2011.

CIclos.PNG

Thanks

Labels (1)
1 Solution

Accepted Solutions
RsQK
Creator II
Creator II

What you could do is create a default bookmark. The process would be:

1) Make sure there are no excess selections that you don't want to make default selections;

2) Navigate to your filter pane with the field you want to filter dynamically (i.e. field name = "Field");

3) paste this into the filter pane and accept the selection (obviously change the "Field" with whatever your actual field is named):

=Field=Maxstring({<Field={"Ciclo $(=Max(Num#(Right(Field,4))))"}>}Field)

4) create a bookmark;

5) set it as a default bookmark.

View solution in original post

2 Replies
avinashelite

You need to set on open triggers, take a look of the below article 

https://community.qlik.com/t5/New-to-Qlik-Sense/Create-a-Trigger-in-Qliksense-on-OPEN-qvf/m-p/118876...

 

RsQK
Creator II
Creator II

What you could do is create a default bookmark. The process would be:

1) Make sure there are no excess selections that you don't want to make default selections;

2) Navigate to your filter pane with the field you want to filter dynamically (i.e. field name = "Field");

3) paste this into the filter pane and accept the selection (obviously change the "Field" with whatever your actual field is named):

=Field=Maxstring({<Field={"Ciclo $(=Max(Num#(Right(Field,4))))"}>}Field)

4) create a bookmark;

5) set it as a default bookmark.