Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator
Creator

Dynamic Book mark with multiple values

I have a current year filter in my dashboard and the customer wants to default the filter for the last 5 years , the challenge is 

the bookmark should be updated dynamically, means this year it should be 2021, 2020, 2019, 2018, 2017 but next year 

the default selections should be 2022,2021, 2020, 2019, 2018.

Any help would be really appreciated.

2 Replies
marcus_sommer

Maybe: >=$(=year(today())-4)

- Marcus

Sammy_AK
Creator II
Creator II

hello,

Please refer to the below links for details on dynamic bookmarks, you can google for more as well 🙂 

https://www.youtube.com/watch?v=d85WIgy35Ig

https://community.qlik.com/t5/New-to-Qlik-Sense/Dynamic-Bookmark/td-p/1578920

https://community.qlik.com/t5/New-to-Qlik-Sense/Dynamic-Bookmark-not-working/td-p/1619140

from the above post, i understand that you would like to select multiple years, which i assume will be based on a logic. if you can pass the logic in the filter and create a bookmark, this should help you. 

e.g. you need to enter this in filter: =Date>2018  or =only({<Date = {2018,2019,2020}>}Date)

here, date is the column on which you want to apply the filter and >2018 is the logic you want to search for and once this is applied, you can save this as a bookmark.