Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
We have done some changes to a Qlikview document a while back and just realized that the bookmarks do not work anymore after the changes. the bookmarks are still there but they do not work. Now we would like to view all the selections stored in the bookmark
Is there some way to see what field selections we had in the bookmark. I have used power tool to view the user bookmarks on the server in the .shared file but I have no idea how to do it for the document bookmarks inside a document
If someone has any idea or knowledge, please share it
Thanks
Maybe with macros like this example from the APIGuide.qvw (is in your install-folder):
set bm = ActiveDocument.GetBookmark("BM01")
if bm.Default = true then
set flditems = bm.Bookmark.FieldItems
for i = 0 to flditems.Count-1
set vals = flditems.Item(i).Values
next
else
msgbox("Bookmark does not exist")
end if
- Marcus
Or you can export the bookmarks, which will create an XML file with the bookmark selections, which you can review manually. In QV desktop, click Bookmarks | Export for each bookmark.
For example (snipped for brevity) with a search string:
<QVBookmarks>
<Bookmark>
<FieldItems>
<BookmarkFieldItem>
<Def>
<Name>GLAccount</Name>
<Type>PRESENT</Type>
</Def>
<SelectInfo>
<TextSearch>(1*|2*)</TextSearch>
...
or with a selection list:
<Values>
<FieldValue>
<Text>FactEFBalance</Text>
<IsNumeric>false</IsNumeric>
<Number>7E37E43C8800759C</Number>
</FieldValue>
<FieldValue>
<Text>FactLedger</Text>
<IsNumeric>false</IsNumeric>
<Number>7E37E43C8800759C</Number>
</FieldValue>
</Values>
If all the selected(bookmarked) metadata values are still there in the app, you might get them listed field-wise like: in a text box use expression like: Concat({bookMarkName} Distinct Field1 , ' ,'). However, this is limited by individual field expression.