topic Re: Possible Syntax Error. Dynamic Date for bookmark in App Development

Possible Syntax Error. Dynamic Date for bookmark

paul1204 — Wed, 21 Aug 2024 17:39:13 GMT

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?

Here's some screenshots to illustrate.

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!

Re: Possible Syntax Error. Dynamic Date for bookmark

Sayed_Mannan — Wed, 21 Aug 2024 18:33:49 GMT

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.