Setting up Dynamic Default Bookmark for Max Date in a table

[aclarke]

Hello, trying to configure my app so that whenever a sheet is opened up, the max date in the table START_TIME is the default filter applied.

Based on the training videos for Qlik Sense, this is done via filtering data in a listbox search on a Table then creating a bookmark off of that.  I'm having trouble creating a search in the listbox for my table START_TIME.autoCalendar.Date to return the max date available. (Date type - formatted MM/DD/YYYY)

Have tried...

=START_TIME.autoCalendar.Date=MAX({1}START_TIME.autoCalendar.Date)

=MAX({1} START_TIME.autoCalendar.Date)

Neither return the max date available in the table.

The idea here is that data will be loaded in daily and I want the filter to update automatically every time I open up my sheet.

Thanks for the help!

[stevejoyce]

Great.  Please mark as solution.