topic Re: get current User selection of Bookmark in QlikView

get current User selection of Bookmark

Wed, 20 Aug 2014 14:59:11 GMT

Hi all,

I have a problem with getting the name of the current bookmark.

is it possible to get the name of the Bookmark wich is selected by User?? Something link getcurrentselection.

either by macro or QlikView area.

Re: get current User selection of Bookmark

shawn-qv — Thu, 21 Aug 2014 04:44:29 GMT

I don't believe there is, but what is the purpose of getting the name of the bookmark?

A bookmark is nothing more than a saved collection of current selections and/or layout state; which you can then use the getfieldselections (or similar) to retrieve the values.

If you're wanting to deconstruct a bookmark file, then perhaps look at "exporting" the bookmark first; but from memory you may have to do some hex conversion to get the field values.

Re: get current User selection of Bookmark

sujeetsingh — Thu, 21 Aug 2014 04:49:13 GMT

Mark,

Try to write some macro in VB script which will provide the name of the current bookmark()

Re: get current User selection of Bookmark

ashfaq_haseeb — Thu, 21 Aug 2014 06:12:06 GMT

Hi,

have a look at attached application.

Regards

ASHFAQ

Re: get current User selection of Bookmark

Thu, 21 Aug 2014 11:19:21 GMT

After the User seleceted a bookmark, he starts an export via button. The export is an marco which exports some tables and graphs as png. The graphics get saved in a folder. In the path of the folder is now the Name of the User like this,

path= 30_QlikView\Username\graphics" instead of Username should stay the name of the selected bookmark.

Re: get current User selection of Bookmark

Thu, 21 Aug 2014 11:28:27 GMT

Hi,

but still there isn't a conection between the selected bookmark and your table, is there?

have a look at my post above, maybe that helps to understand what is my problem

Re: get current User selection of Bookmark

sangland2 — Wed, 11 Feb 2015 07:18:11 GMT

I found this post looking for some way to get the selected book marks. Reason - I have a report that requires a particular bookmark to be selected, if it isn't then the report is wrong. Instead of worrying about the bookmark I check for the data that the book mark should have found. Add a calculation condition to the report eg

sum(if(Status = 'B',[Line Value],

if(Status = 'U',[Line Value],0)

)

) > 0

If these status are not selected then the value is zero and the condition is not met. Then in error messages for "Calculation condition unfulfilled" the custom message is "Please select Status "B" and/or "U" or use the Status bookmark".