topic Re: Macro get content of variable doesn't work in QlikView

Macro get content of variable doesn't work

Thu, 01 Jan 2015 12:59:14 GMT

Hey,

When I tried to do this:

temp = ActiveDocument.Variables("vTemp").GetContent.String

path = Replace(path, "{1}", temp)

And I get nothing.

When I declare the variable in the module like this, it works :

temp = "temp"

path = Replace(path, "{1}", temp)

The "vTemp" variable declared in the Variable Overview.

What is the problem?

Thanks.

Re: Macro get content of variable doesn't work

rwunderlich — Thu, 01 Jan 2015 18:56:09 GMT

Are you calling the macro from the script or from the UI?

-Rob

Re: Macro get content of variable doesn't work

jagan — Fri, 02 Jan 2015 02:06:00 GMT

Hi,

It is not suggested to use macros if you can achieve the same without using the macros. Always try to avoid macros, some doesn't works in Ajax mode.

Anyway to achieve your requirement use below macro

SUB setVariable()
set v = ActiveDocument.GetVariable("vTemp")
vTempValue = v.GetContent.String
set v = ActiveDocument.GetVariable("path")
v.SetContent Replace(v.GetContent.String, "{1}", vTempValue), true
END SUB

Hope this helps you.

Regards,

Jagan.