Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Document and User Bookmarks in a listbox

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

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Document and User Bookmarks in  a listbox

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.


talk is cheap, supply exceeds demand

View solution in original post

4 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Document and User Bookmarks in a listbox

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


talk is cheap, supply exceeds demand
Highlighted
New Contributor III

Re: Document and User Bookmarks in a listbox

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: Document and User Bookmarks in  a listbox

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.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
New Contributor III

Re: Document and User Bookmarks in  a listbox

Gysbert,

Thank you....

It worked.....