topic Dynamic Bookmark filtering in QlikView

Dynamic Bookmark filtering

kapil_rthr — Mon, 25 Nov 2019 06:03:10 GMT

i have a multi box which shows the months as :

Jan

Feb

Mar

...

Dec

i want to create a bookmark which should always select the last three months.

for example :

if i select a bookmark today on 25th Nov: Aug, Sep, Oct filters should be applied

if i select the same bookmark on 10th Dec: Sep, Oct, Nov should be selected.

BR-

Kapil Rathore

Re: Dynamic Bookmark filtering

Brett_Bleess — Mon, 09 Dec 2019 18:18:32 GMT

Kapil, I believe the better option in this case may be a Button object where you could use the associated Actions to make that selection. The purpose of a bookmark is to statically represent the state of things when it is created, so trying to make that dynamic is not likely going to work well at all. I would have a look at the Button object and the Selection actions associated with it to see if you can work things out that way. This is the best alternative of which I can think other than simply using Set Analysis expressions to handle things.

Regards,
Brett