topic Setting up Dynamic Default Bookmark for Max Date in a table in App Development

Setting up Dynamic Default Bookmark for Max Date in a table

aclarke — Sat, 16 Nov 2024 05:55:39 GMT

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!

Re: Setting up Dynamic Default Bookmark for Max Date in a table

g_fernandez_l — Wed, 16 Oct 2019 18:35:09 GMT

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"}>}

Re: Setting up Dynamic Default Bookmark for Max Date in a table

harithad95156 — Wed, 15 Sep 2021 13:59:23 GMT

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?

Re: Setting up Dynamic Default Bookmark for Max Date in a table

stevejoyce — Wed, 15 Sep 2021 14:24:42 GMT

what if you add total to your max date calculation

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

Re: Setting up Dynamic Default Bookmark for Max Date in a table

harithad95156 — Wed, 15 Sep 2021 15:20:19 GMT

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 ?

Re: Setting up Dynamic Default Bookmark for Max Date in a table

harithad95156 — Wed, 15 Sep 2021 15:28:35 GMT

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 ?

Re: Setting up Dynamic Default Bookmark for Max Date in a table

stevejoyce — Wed, 15 Sep 2021 15:29:56 GMT

Did you try the formula with the Total? I don't see why you need to bring in period and make it more complicated.

Re: Setting up Dynamic Default Bookmark for Max Date in a table

harithad95156 — Wed, 15 Sep 2021 16:14:20 GMT

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.

Re: Setting up Dynamic Default Bookmark for Max Date in a table

stevejoyce — Wed, 15 Sep 2021 21:34:15 GMT

I highlighted the update below:

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

Re: Setting up Dynamic Default Bookmark for Max Date in a table

harithad95156 — Thu, 16 Sep 2021 03:11:04 GMT

Greatly appreciated!!

Many thanks Stevejoyce.

Received the desired outcome😀

Re: Setting up Dynamic Default Bookmark for Max Date in a table

stevejoyce — Thu, 16 Sep 2021 09:29:10 GMT

Great. Please mark as solution.