topic Re: How to pass a variable to macro in qlikview? in QlikView

How to pass a variable to macro in qlikview?

srinivas1921 — Wed, 31 Aug 2016 16:55:22 GMT

Hi,

I have created a variable for company and I also created a button to pass this variable to micro in my application. I couldn't pass this variable to macro when I click on button.

Please provide macro to pass a variable and suggest solution on this.

Many thanks in advance.

Re: How to pass a variable to macro in qlikview?

tresB — Wed, 31 Aug 2016 17:01:04 GMT

Try like:

set v = ActiveDocument.GetVariable("vMyVariable")

Re: How to pass a variable to macro in qlikview?

srinivas1921 — Wed, 31 Aug 2016 17:12:58 GMT

Hi Amit,

I already tried this but it was not working...

Re: How to pass a variable to macro in qlikview?

santiago_respane — Wed, 31 Aug 2016 17:19:59 GMT

Hi,

i use a function as follows:

'Function declaration

FUNCTION getVariableValue(varName)

set v = ActiveDocument.Variables(varName)

getVariableValue = v.GetContent.String

END FUNCTION

'Function use example

sub x

myVarValue = getVariableValue("v.MyVarName")

msgbox myVarValue

end sub

Please let me know if this helps.

Kind regards,

Re: How to pass a variable to macro in qlikview?

spring101 — Fri, 09 Apr 2021 14:27:26 GMT

This function helped me. Thanks!