Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Date field in "YYYY-MM" format which contains the month values. I want only one month to be selected, so on field settings I selected "Always one selected value". When I open the app, I want by default that latest (max) month to always be selected by default. I saw that it can be done using the bookmark, but I am not able to write the correct filter expression for the Date field since it is a "YYYY-MM".
Two options i would make sure the field is seen a Date field,
Date([Date Field], 'YYYYY-MM') AS [Date Field]
then try the max again.
Second
flag the current month in script and add an action to select month where flag = 1 something like
ONLY({<Flag={1}>}[Date field])
you can use a filter object to create a 'calculated bookmark', within the filterobject you can use expressions to search. for example if you use @Mark_Little expression in this it will find the latest month. with this selection selected you can create a bookmark that always opens on the current month when opening an app. then in the frontend set this bookmark as the default bookmark on opening and you got the current month selected when opening this app.
Solved: preselected max value while open an App - Qlik Community - 1681234
You may use a dynamic bookmark as illustrated above but that did not work for me.
Or you can use a date range picker object (this is an extension), using "This Month", save it as a bookmark and make it as default. This works fine with the option always one selected value
Regards,
Riccardo