topic Re: Use of variables in macros in QlikView

Use of variables in macros

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have added a variable called "AverageOfCountry" using "Variable Overview>Add" from Layout. I defined the variable using an expression. How can I evaluate the expression linked to the variable and use it in a macro? I have to use it in a macro because I need the said variable's value on every sheet of the excel document I'm exporting to.

Re: Use of variables in macros

marcus_sommer — Mon, 08 Jan 2018 13:30:29 GMT

Maybe with something like:

v = ActiveDocument.Variables("AverageOfCountry").GetContent.String

- Marcus

Re: Use of variables in macros

Clever_Anjos — Mon, 08 Jan 2018 13:30:55 GMT

this will retrieve your variable value

ActiveDocument.GetVariable("AverageOfCountry").GetContent.String

Re: Use of variables in macros

Anonymous — Mon, 08 Jan 2018 13:59:29 GMT

Well it pastes me the expression string in the Excel table, not the value I would get by evaluating the expression. How do I get the variable expression to evaluate?

Re: Use of variables in macros

martinpohl — Mon, 08 Jan 2018 14:04:00 GMT

so set the variable with "=" in front of the expression that the value is calculated.

Regards

Re: Use of variables in macros

OmarBenSalem — Mon, 08 Jan 2018 14:05:26 GMT

ActiveDocument.GetVariable("AverageOfCountry").getContent.string

and make sure ur variable begins with "=" when created

Re: Use of variables in macros

Clever_Anjos — Mon, 08 Jan 2018 14:09:48 GMT

Use "=" at beginning of your variable

Re: Use of variables in macros

marcus_sommer — Mon, 08 Jan 2018 14:11:32 GMT

Another way might be to use evaluate() for the variable or maybe the expression itself - maybe like this: Re: How to export formula with Set analysis using macro

- Marcus

Re: Use of variables in macros

Anonymous — Mon, 08 Jan 2018 14:13:36 GMT

that's it. Thank you!

Re: Use of variables in macros

dhasharadh — Tue, 08 Sep 2020 09:31:14 GMT

Dear all,

i have a similar requirement, am using a macro to export my tables into txt format and want to keep prefix as current date to that generated txt files

i used below F:\Document\$(vDate)_wang.txt --- and it is getting named as it it, it is not picking the current date, Please help me. Thanks much