Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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"}>}
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?
what if you add total to your max date calculation
=START_TIME.autoCalendar.Date=MAX({1}TOTAL START_TIME.autoCalendar.Date)
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 ?
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 ?
Did you try the formula with the Total? I don't see why you need to bring in period and make it more complicated.
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.
I highlighted the update below:
=START_TIME.autoCalendar.Date=MAX({1}TOTAL START_TIME.autoCalendar.Date)
Greatly appreciated!!
Many thanks Stevejoyce.
Received the desired outcome😀