topic Re: how to override a bookmark value of variable in Qlikview ? in QlikView

how to override a bookmark value of variable in Qlikview ?

rajumachra — Mon, 27 Nov 2017 10:52:07 GMT

Background : We are using vStartDate and vEndDate variables to hold our start and end dates. We are checking include in bookmark in variable setting so that our variable value is transferred in document chaining .

We have many time periods like month to date (MTD) where vEndDate is getting updated after every Prod Refresh . So basically vEndDate is getting updated everyday .

Issue : Now lets say user created a bookmark with MTD or whatever PERIOD they were looking at (Atleast one timeperiod will be selected everytime) on 20th Nov . So vEndate will have numerical value of endate stored inside bookmark because we have checked "include in bookmarks" checkbox in variable setting .

Now user comes back again on 27th Nov and hits that bookmark . Qlikview will overide current value of vEndate (Numerical value of 27th) with that of 20th (Date on Which we created the bookmark). Now this is very misleading because our user is thinking that it is seeing the data till 27th whereas in reality Qlikview has overided the vEnddate value and he is seeing data till 20th .

What We want : we need a way so that this stops and our variable value will not be affected/changed by bookmark . Even If user is applying bookmark We should see data till 27th !

ThankYou !

Re: how to override a bookmark value of variable in Qlikview ?

rajumachra — Wed, 06 Dec 2017 09:19:44 GMT

hic‌gwassenaar‌lokatech‌QlikView App Development‌QlikView Forums & Resources‌@

Re: how to override a bookmark value of variable in Qlikview ?

rajumachra — Wed, 06 Dec 2017 09:20:33 GMT

Your thoughts on this ?

Re: how to override a bookmark value of variable in Qlikview ?

hic — Wed, 06 Dec 2017 09:35:42 GMT

If you want to use "today's" value of vEndDate, instead of the value vEndDate had when the bookmark was created, then you should NOT include the variable in the bookmark.

Including the variable in the bookmark means exactly that which you want to avoid: That the current variable value will be stored in the bookmark when the bookmark is created, and applied when the bookmark is applied.

HIC

Re: how to override a bookmark value of variable in Qlikview ?

rajumachra — Wed, 06 Dec 2017 09:45:07 GMT

Thank You Sir for your Response ! But if we do that then out document chaining will suffer . We need to pass the values of vStartDate and vEndDate in document chaining .