Creating dynamic date bookmarks

pauledrich — Mon, 30 Dec 2013 11:02:41 GMT

Hi and thanks for any help on this topic.

I have read numerous posts within the community & external blogs but don't seem to be able to create the solution.

I have the need to create a variety of bookmarks relating to dates and to start with wanted to create a bookmark for today which refreshes every day. I have:-

1. Created a search string from a 'Date' list box of '=Date=date(Today(1))'

2. Created a new bookmark 'BM01'

3. Added an on Open event trigger 'Select in Field' - Field is 'Date', Search String is '=Date=date(today(1))'

4. Added a further action to the trigger of replace bookmark 'BM01'

Works fine for today but tomorrow selects yesterday - I have read Qlikview Notes: Initial Selections and Current Selections which was helpful but doesn't solve my problem.

In addition - I am looking to create a bookmark which selects the last 12 months excluding this month which would refresh - in my script I have 'Year(Today())-Year(TransactionDate)) + Month(Today()) - Month(TransactionDate) as MonthsAgo'.

By using '=MonthsAgo>0' & '=MonthsAgo<13 works fine until I bookmark, selection of the bookmark is >0

Any help, as always is appreciated.

Re: Creating dynamic date bookmarks

pauledrich — Tue, 21 Jan 2014 13:22:03 GMT

Can anyone help with this question?

Re: Creating dynamic date bookmarks

maxgro — Tue, 21 Jan 2014 13:49:01 GMT

did you also read this?

Bookmarks Dynamic Selections | QlikCommunity

topic Re: Creating dynamic date bookmarks in QlikView

Creating dynamic date bookmarks

Re: Creating dynamic date bookmarks

Re: Creating dynamic date bookmarks