topic Re: Document and User Bookmarks in a listbox in QlikView

Document and User Bookmarks in a listbox

Anonymous — Thu, 25 Feb 2016 16:46:33 GMT

Hello experts,

I am looking for some help in creating a list box with both user and document bookmarks. When I did some research I found a way to create a list box with document bookmarks but is there a way to have a list box with user bookmarks as well. I am looking for a way avoiding macros. Any help would be highly appreciated.

Thanks

Heera

Re: Document and User Bookmarks in a listbox

Gysbert_Wassenaar — Thu, 25 Feb 2016 16:54:39 GMT

Afaik that's not possible. User bookmarks are not stored in the document itself, but in the .shared file associated with the document.

Re: Document and User Bookmarks in a listbox

Anonymous — Thu, 25 Feb 2016 17:31:39 GMT

Gysbert,

Thanks for the quick response, I tried couple of ways in having the document bookmarks in a list box, but I am not successful. Can you please let me know how to have document bookmarks in a list box without using a macro.

Thanks

Heera

Re: Document and User Bookmarks in a listbox

Gysbert_Wassenaar — Thu, 25 Feb 2016 17:42:41 GMT

If you want to create a table with the bookmarks then you first need to export them to a file using the Export option in the Bookmarks menu. Then you have to load the data from that file into a table with something like

Bookmarks:

LOAD Replace(Id,'Document\','') as Id,

Name

FROM (XmlSimple, Table is [QVBookmarks/Bookmark]);

You will then have a table with the names and id's of the bookmarks. You then need to add an Apply Bookmark action to the OnSelect trigger of the Name and/or Id field (depends what you intend to use in the listbox). You can use =Only(Id) as value for the Bookmark ID of the action.

Re: Document and User Bookmarks in a listbox

Anonymous — Thu, 25 Feb 2016 17:52:52 GMT

Gysbert,

Thank you....

It worked.....