
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
