Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
eddyg
Contributor
Contributor

Select latest month by default when Always one selected value on field

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

Labels (2)
3 Replies
Mark_Little
Luminary
Luminary

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])

 

MartW
Partner - Specialist
Partner - Specialist

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.

Rick_07011
Contributor II
Contributor II

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