Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Maybe: >=$(=year(today())-4)
- Marcus
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.