Select max(Statement Date) in selection , whenever the user open the Qliksense App ?

[suvechha_b]

Hi All,

How can I select max(Statement Date) in the filter dynamic, say for example if data is loaded today then tomorrow my selection should show '2019-05-04' as selection. sample model attached

[miskinmaz]

use bookmark and set that bookmark as app default. To make the bookmark dynamic follow below link:

https://www.youtube.com/watch?v=tFyqOigqnUw

[suvechha_b]

Hi Miskinmaz,

Please kindly assist to get the max([Statement Date]) selected when the Qliksense App is open. I did the bookmark but unable to create the function to get the latest [Statement Date].

sample model attached.

[miskinmaz · Accepted solution]

In search bar of filter use below expression:

=[Statement Date]=vDate

I have create a variable to get the max date.

Attaching the file for the same.

[suvechha_b]

Thanks, it worked.Please kindly explain step by step as I can't find the vDate variable in the App. It will help me to implement it on other App .

[miskinmaz]

You can see the variable in the variable section of the app. Please refer the below screenshot.

After this write the expression mentioned earlier in search expression of the filter.

Then create a bookmark and mark it as app default.