
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Setting up Dynamic Default Bookmark for Max Date in a table
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!
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @aclarke .
To resolve this issue you need to generate a new field in the script that only have the max value . Then filter in the field where you want to select the max value as follow then
=<New Field>
In My example you can see that the Field Periodo2 has only one value.
After do that, press enter to confirm the selecction and create a new bookmark, and set that like default selecttion. The bookmark detail is set like
{<Field={"=NewField"}>}.
In my example is
{<AñoMes={"=Periodo2"}>}

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Fernandez,
I have tried this by creating a field in script level and when using the same field in frontend searchbar it is not displaying the max monthyear.
Can you please suggest me the reason?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
what if you add total to your max date calculation
=START_TIME.autoCalendar.Date=MAX({1}TOTAL START_TIME.autoCalendar.Date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have added a field in script like maxstring(MonthYear) as Period .
In front end for the respective field which is MonthYear, I have searched like =Period but it is not showing max value instead selecting all field values.
How to get max value in MonthYear field when having =period expression in searchbar ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I have added a field in script like maxstring(MonthYear) as Period .
In front end for the respective field which is MonthYear, I have searched like =Period but it is not showing max value instead selecting all field values.
How to get max value in MonthYear field when having =period expression in searchbar ?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Did you try the formula with the Total? I don't see why you need to bring in period and make it more complicated.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you please brief where do I need to place this formula?
I have a field MonthYear.
In searchbar for MonthYear field what needs to be written to execute dynamic bookmark wherein I require max of monthyear dynamically.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I highlighted the update below:
=START_TIME.autoCalendar.Date=MAX({1}TOTAL START_TIME.autoCalendar.Date)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Greatly appreciated!!
Many thanks Stevejoyce.
Received the desired outcome😀

- « Previous Replies
-
- 1
- 2
- Next Replies »