Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello good people of the Qlik Community
We have a Year drop down and the User can select the Year they want to view.
The problem is that it defaults to year 2023 when entering the sheet.
We want to change it to use a dynamic value GL.Year = Year((Today(0)). but when doing so, the expression is blank on the bookmark.
What am I missing?
Heres the bookmark
Here's an example where it's hardcoded a year. We don't want a hardcoded year, would like to have Year(Today(0)) to keep it dynamic
I'm able to achieve this using the Action, but it only applies to one sheet in a application. Looking for more of a "global" config where all sheets in the app use Year(today(0)) as the Year selection
Cheers!
To set a dynamic default year in Qlik Sense bookmarks, you can use the following approach:
1. Create a new variable, e.g., vCurrentYear, with the definition: Year(Today()).
2. Create a bookmark with the desired selections. Instead of hardcoding the year, use the variable you created. For example, in the Year field, use =$(vCurrentYear)
3. Ensure that the bookmark is applied when the sheet is opened. You can do this by setting the bookmark as the default bookmark for the sheet.
This method ensures that the bookmark dynamically updates to the current year whenever the sheet is accessed.
If you encounter issues with the expression being blank, double-check the variable definition and ensure it is correctly referenced in the bookmark. Additionally, verify that the variable is properly defined and accessible in the context where the bookmark is applied.
Look like this, inside the search box:
=[POI Date.Year]=Year(Today())
- Matheus
Helpful explanation — using a dynamic variable like `vCurrentYear` makes the bookmark more flexible and avoids manual yearly updates.
For presentation or documentation, a font generator or Schriftgenerator can also help make headings, notes, and dashboard descriptions look cleaner and more engaging.