To assign macro variable value to qlikview variable.

[saumyashah90]

I have macro varialble name vColor,and i want to assign value of vColor to a qlikview variable vAlpha.How can i do it?

[kuba_michalik · Accepted solution]

What do you mean by macro variable? Variable in the macro module? If so, then:

set v = ActiveDocument.Variables("vAlpha")

v.SetContent vColor, true

If the QlikView variable did not exist before, you can create it with

ActiveDocument.CreateVariable "vAlpha"