Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 (2)
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.