Dynamic bookmark

[DanielleW1]

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

[theoat · Accepted solution]

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]

This works perfect, thanks very much!