topic Re: Bookmark ID - how to create bookmarks without overwriting old ones in QlikView

Bookmark ID - how to create bookmarks without overwriting old ones

Thu, 27 Aug 2015 14:10:41 GMT

Hi all - I'm looking to make a button to create bookmarks but I don't know what to put for the ID to make sure that I'm only adding and not overwriting a previous bookmark. I'd like to make it so that if someone were to hit bookmark in rapid succession, they'd just add Bookmark 1, Bookmark 2, and Bookmark 3. Thanks!

Re: Bookmark ID - how to create bookmarks without overwriting old ones

Gysbert_Wassenaar — Thu, 27 Aug 2015 14:39:36 GMT

You could use the current date and time: ='BM' & floor(num(now())*8640000)

Re: Bookmark ID - how to create bookmarks without overwriting old ones

Thu, 27 Aug 2015 15:10:13 GMT

Awesome - this worked perfectly. Thank you!

Re: Bookmark ID - how to create bookmarks without overwriting old ones

Thu, 27 Aug 2015 18:17:13 GMT

in the above expression why we need to multiply with 8640000?

Re: Bookmark ID - how to create bookmarks without overwriting old ones

Thu, 27 Aug 2015 19:18:08 GMT

I multiplied by 84600 instead, which is 60 x 60 x 24 - the number of seconds in a day. Gysbert's version was just 10x more accurate. It makes it so that clicking the button will append the exact time when your bookmark was made, to the second, as the bookmark ID number. That makes it much more difficult to overwrite a bookmark by clicking the button quickly (though if you were to double-click within a second, I imagine it would overwrite the first click).