Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

rank_nandha
Contributor II

Latest Date record in filter

Hi All,

I have a filter called Reporting Period in the dashboard. I want to select the latest date value by default when ever i open the app.

i.e., in the attached image value Jul-15 have to be selected by default or always when open the app. If the data loaded and the latest value is Dec-15 then that has to be selected. Also this has to be sorted according to latest value.

RP.png

We can do this with the help of a Trigger in QV. Please let me know how can we do this in QS.

Regards,

Nandha

3 Replies
balrajahlawat
Esteemed Contributor

Re: Latest Date record in filter

may be like this in QV, not sure about QS:

Go to Document Settings ->Triggers->DocumentEventTriggers->Select "OnOpen" -> Click AddAction->Add ->Selection->Select In Field->OK

Then you have to put your datefield in the "Field" and put : =max(DateField) in the "Search String"

ogster1974
Honored Contributor II

Re: Latest Date record in filter

Triggers are not supported yet in Qlik Sense.

To meet your requirement in Qlik Sense I'd Create a bookmark that saves your desired default stage and save the app so it opens in that state.

As far as sorting lists go assuming you have a proper date associated with that field you can use sort by expression to sort on the actual rather than display date.

Hope this helps

Regards

Andy

reddys310
Honored Contributor II

Re: Latest Date record in filter

Hi NandhaKumar,

This functionality is not yet available in QlikSense.