Bookmarks Dynamic Selections

Anonymous — Mon, 30 Dec 2013 14:55:19 GMT

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?

Re: Bookmarks Dynamic Selections

Gysbert_Wassenaar — Mon, 30 Dec 2013 15:17:08 GMT

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.

topic Re: Bookmarks Dynamic Selections in QlikView

Bookmarks Dynamic Selections

Re: Bookmarks Dynamic Selections