Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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

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

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
Contributor III
Contributor III

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

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
Contributor III
Contributor III

Gysbert,

Thank you....

It worked.....