Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Bookmarks Dynamic Selections

I'm creating Bookmarks with following selections. Those selections are based on Year, WeekNumber etc. after a week when a new week is added and I go to the bookmark I do not see the current week as the latest but the one selected at the time Bookmark was created.

Is there a way to point Bookmarks to current week?

BMI.png

1 Reply
Gysbert_Wassenaar

The bookmark can't be dynamic like you want. But there is a way to achieve the same. Create an IsCurrentWeek field in the script.

LOAD ..some_fields..

    , WeekNumber

    , if(week(today())=WeekNumber,1,0) as IsCurrentWeek

FROM ...;

Then redefine your bookmark so that includes the selection of 1 in the IsCurrentWeek field. This field will be updated every reload so your bookmark won't have to change anymore.


talk is cheap, supply exceeds demand