topic Re: Macro script for current selections.. in QlikView

Macro script for current selections..

sravan_v007 — Wed, 13 Sep 2017 07:40:18 GMT

Hi All,

I have a requirement, where I need to identify current selections i.e. Object Name, ObjectID and Selected Values.

So, I fount two different VBScripts. Please find below the 2 scripts.

Now I need your help to club both the scrips..

1. For identifying Object Name:

SUB Objects()

Shtobj = ActiveDocument.ActiveSheet.GetSheetObjects

for i = lBound(Shtobj) to uBound(Shtobj)

Obj = Shtobj(i).GetCaption.Name.v

ObjId = Shtobj(i).GetObjectId

if instr(Obj, "Month Name") then

msgbox Obj

msgbox ObjId

end if

END SUB

2. For identifying Selected Values:

sub theFieldValues ()

set myfield = ActiveDocument.Fields("Month Name").GetPossibleValues

for i=0 to myfield.count-1

K = myfield.Item(i).Text

msgbox K

end sub

Thanks in Advance.

Re: Macro script for current selections..

marcus_sommer — Wed, 13 Sep 2017 11:07:33 GMT

Whats the aim behind this query? I fancy it could be reached without macros just with native qlikview features.

- Marcus

Re: Macro script for current selections..

sravan_v007 — Wed, 13 Sep 2017 11:29:33 GMT

Hi Marcus..

Requirement: Users want a Button which will allow them to create link with current selections. which they can share with other users through a mail.

i.e. in simple words user want to create a Server Bookmark which they can share with others using mail link.

Issue: We can create User and Document bookmarks but we can't create Server bookmarks. So, I am trying to identify selections, store them in a variable and later in a link.

Something like below.

AJAX and URL parameters

Re: Macro script for current selections..

prieper — Wed, 13 Sep 2017 12:17:46 GMT

Have you tried
"More" -> "Mail with Bookmark as a Link" within the webclient?

Re: Macro script for current selections..

sravan_v007 — Thu, 14 Sep 2017 09:53:10 GMT

Hi Peter,

Thanks for Mail with Bookmark as a Link option.

But, Is it possible to put similar functionality as an Action button..

Thanks,