2 Replies Latest reply: Jan 22, 2014 2:16 PM by Massimo Grossi RSS

    Creating dynamic date bookmarks

    Paul Edrich

      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.

       

      P