Default a filter to maximum date in Qlik sense

[mirasubramanian7]

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

[anat]

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

[vikasmahajan]

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

[vikasmahajan]

Like this