topic Re: Get bookmark name by macro in QlikView

Get bookmark name by macro

Thu, 21 Nov 2013 16:00:24 GMT

Hi all,

is it possible with macro code to get the current Bookmark name applied in a qlikview?

The aim is to catch the applied bookmark, to add a selection in field and then to replace the same bookmark with new selection (bookmark + new field selection).

Is it possible?

Thanks in advance,

Davide

Re: Get bookmark name by macro

rajeshvaswani77 — Tue, 23 Sep 2014 13:13:42 GMT

Hi All,

Is it possible to pass the bookmark name and get the ID of the bookmark?

thanks,

Rajesh Vaswani

Re: Get bookmark name by macro

zippo_btl — Fri, 01 Sep 2017 08:35:53 GMT

sub run

vBMMaxNum=ActiveDocument.GetVariable("vBMMaxNum").GetContent.String
dim IterNo
dim vBMID
IterNo=vBMMaxNum
DO
if IterNo<10 then
vBMID="BM0"&IterNo
else
vBMID="BM"&IterNo
end if
BMName = vBMID
if ActiveDocument.GetBookmark(vBMID).Default = true then
vBMMaxNum=IterNo
end if

IterNo=IterNo+1
Loop While (IterNo<=2000)
ActiveDocument.GetVariable("vBMMaxNum").SetContent vBMMaxNum, True

end sub

The idea is to loop throw possible bookmarks, checking if the bookmark exists. If the bookmark exists u can compare its name with a given name. Bookmark names must be uniq. This method works on local pc and doesn't work in AJAX. It should work through "open in server"