Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

We value your feedback – take our 5-minute QlikView modernization survey
Showing results for 
Search instead for 
Did you mean: 

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?


1 Reply

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