Get a Macro variable in Qlikview

Tue, 18 Jul 2017 02:17:01 GMT

Hi ,

I'm trying to get the current active object into a Qlikview variable.

I did a Macro where I have a vbscript variable. It' working

Set ContainerObj = ActiveDocument.GetSheetObject("DUP")

set ContProp=ContainerObj.GetProperties

var= ContProp.SingleObjectActiveIndex

msgbox "var = " & var

end sub

Do you know how I can bring that in my app in order to use it?

Thanks

Cheers

Re: Get a Macro variable in Qlikview

marcus_sommer — Tue, 18 Jul 2017 06:14:06 GMT

If your creates a variable "YourVariable" in your application you could fill them with:

...

ActiveDocument.Variables("YourVariable").SetContent var, true

...

- Marcus