Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
This works perfect, thanks very much!