Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
mstoler
Partner - Specialist
Partner - Specialist

using a variable in a bookmark

Hello,

In my data model I have a calendar with a Year field . I also have a variable vCurrentYear which is set to Year(today()).

Is there a way to create a bookmark where part of the bookmark is set set Year to the variable $(vCurrentYear).

As an alternative I can just add a field CurrentYear to my data model and make that part of my bookmark.

Thanks,

Michael

Labels (2)
1 Solution

Accepted Solutions
albertovarela
Partner - Specialist
Partner - Specialist

Create a filter pane with the field Year, perform the search:  =Year=$(vCurrentYear)  and hit enter, then create the bookmark.

View solution in original post

4 Replies
albertovarela
Partner - Specialist
Partner - Specialist

Create a filter pane with the field Year, perform the search:  =Year=$(vCurrentYear)  and hit enter, then create the bookmark.

mstoler
Partner - Specialist
Partner - Specialist
Author

Very clever and then bookmark the -1 value. 

I like it!

Michael

JacobForssell
Partner - Contributor II
Partner - Contributor II

Does anyone know if this still is possible? I am trying this but it does not seem to work for me

Ken_T
Specialist
Specialist

this works but is tricky.  you need to do the search with the column name and variable as described above, be sure to press enter on the keyboard (do not use the check mark to select the value!!) and also be sure the bookmark has the option checked to include variable state