topic Re: How to keep previous bookmark data when replacing a bookmark? in QlikView

How to keep previous bookmark data when replacing a bookmark?

Fri, 02 May 2014 03:32:58 GMT

I have a bookmark BM01 which stores the selections: ProductID = { 1 , 2 , 3 }

Now I want to replace this bookmark with a new selection: ProductID = { 4 ,5 , 6 } but i want to still keep the selection ProductID = { 1 , 2 , 3 } as well.

So, I want my new BM01 to be: ProductID = { 1 , 2 , 3 , 4 , 5 , 6 }.

How can I do this?

Thank you!

Re: How to keep previous bookmark data when replacing a bookmark?

jagan — Fri, 02 May 2014 04:20:15 GMT

Hi,

Try like this

==Sum({$1} MeasureName) + Sum(MeasureName)

$1 for Previous Selections

Regards,

Jagan.

Re: How to keep previous bookmark data when replacing a bookmark?

Fri, 02 May 2014 09:05:27 GMT

Hi.

It works. Thanks a lot.

But is it possible to do this for more than 2 consecutive selections?

i.e. if I want to keep adding more and more selections while preserving all the old ones?

Thanks!

Re: How to keep previous bookmark data when replacing a bookmark?

jagan — Fri, 02 May 2014 10:25:29 GMT

Hi,

For second previous selection use {$2}, for third previous selectin use {$3}, ...n.

Please close the discussion by giving Correct and Helpful answers to the useful posts, if your requirement is solved it helps others in finding the correct answers.

Regards,

Jagan.

Re: How to keep previous bookmark data when replacing a bookmark?

Fri, 02 May 2014 11:18:06 GMT

Works. Thanks!