topic Re: Default a filter to maximum date in Qlik sense in App Development

Default a filter to maximum date in Qlik sense

mirasubramanian7 — Thu, 20 Jan 2022 22:23:49 GMT

Hello,

I am new to Qlik Sense. I have a filter in the app that selects the (As of Date) from a field. Wondering how to default the selection to the most recent date when no selections are applied. It defaults to the least recent date now.

Thank you so much in advance.

Mira

Re: Default a filter to maximum date in Qlik sense

anat — Fri, 21 Jan 2022 06:02:03 GMT

can u give a try like =if(isnull(getcurrentselection()),Max(date))

Re: Default a filter to maximum date in Qlik sense

vikasmahajan — Fri, 21 Jan 2022 09:39:40 GMT

You can try sheet trigger option :

Selecet Sheer properties
Actions
Label : Currenct Year
Action : Select Values in Field
Field : Year
Value : Max(Year) // this will pickup year dynamically.

Click on Apply & Save

Close application and open again you will get automatically dynamic filter in your dashboard.

Hope this solve your issue.

Vikas

Re: Default a filter to maximum date in Qlik sense

vikasmahajan — Fri, 21 Jan 2022 09:40:32 GMT

Like this