topic Re: how to view the content/selections of a document bookmark in QlikView

how to view the content/selections of a document bookmark

Thu, 11 Feb 2016 08:06:15 GMT

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

Re: how to view the content/selections of a document bookmark

marcus_sommer — Thu, 11 Feb 2016 08:14:20 GMT

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

else

msgbox("Bookmark does not exist")

end if

- Marcus

Re: how to view the content/selections of a document bookmark

jonathandienst — Thu, 11 Feb 2016 08:32:47 GMT

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:

<Def>

<Name>GLAccount</Name>

<Type>PRESENT</Type>

</Def>

<TextSearch>(1*|2*)</TextSearch>

...

or with a selection list:

<Text>FactEFBalance</Text>

<IsNumeric>false</IsNumeric>

</FieldValue>

<Text>FactLedger</Text>

<IsNumeric>false</IsNumeric>

</FieldValue>

</Values>

Re: how to view the content/selections of a document bookmark

tresB — Thu, 11 Feb 2016 08:52:54 GMT

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.