Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Venkat3
Contributor II
Contributor II

Setting up default filters in QlikView

Hi All,

We have a Year field in my dashboard and it contains 2019,2020,2021 & 2022 as values.

Whenever I open the dashboard by default 2021 & 2022 should be selected.

have tried with the select field in document properties->Trigger->Onopen , but it takes only one value i.e 2021 only.

 

can you please help on the above query? tq.

 

Regards,

Venkat

 

 

 

Labels (1)
1 Reply
deepanshuSh
Creator III
Creator III

Hi Venkat, there is quite an easy way to do it, just create a bookmark with the required filters on i.e 2021, 2022 to be selected and in sheet properties set the action to apply bookmark (the one you created with layout and selections). 

Another way is to create a variable and set its value to vMaxYear= max(year)-2,  then create a button of MaxYear and set change value of variable using and if and else condition. and set it in the action on sheet, to 1

 

or creating a simple trigger select in field with max (year)-2

 

Trial and error is the key to get unexpected results.