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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
DanielleW1
Contributor III
Contributor III

Dynamic bookmark

I need to set up dynamic bookmarks to pull in variables, however I am stuck getting one of them to work.

The ones I currently have which do work are something like this:

=Week=$(vCurrentWeek)

 

However, I have a Day Of Week field that needs to dynamically pull in the days of the current week.
I have a variable set up during the load script vCurrentDays, which resolves as: {'Mon','Tue','Wed'} etc.

When I test out the dynamic bookmark I put into the filter:

[Day Of Week]={'Mon','Tue'} and this will work, however the following does not work:

[Day Of Week]=$(vCurrentDays)

 

I have tried out a few different methods, changing the bracket types, removing brackets altogether, but I am having no luck.

 

Thanks in advance

Labels (2)
1 Solution

Accepted Solutions
theoat
Partner - Specialist
Partner - Specialist

Hello,

You can try to make this selection, and after this create your bookmark :

{<[Day Of Week]={"=[Day Of Week]<=weekday(today())"}>}

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

View solution in original post

2 Replies
theoat
Partner - Specialist
Partner - Specialist

Hello,

You can try to make this selection, and after this create your bookmark :

{<[Day Of Week]={"=[Day Of Week]<=weekday(today())"}>}

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

DanielleW1
Contributor III
Contributor III
Author

This works perfect, thanks very much!