topic Re: Setting up default filters in QlikView in App Development

Setting up default filters in QlikView

Venkat3 — Tue, 30 Aug 2022 14:23:08 GMT

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

Re: Setting up default filters in QlikView

deepanshuSh — Tue, 30 Aug 2022 16:53:34 GMT

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