topic Button Macro to Create Variable for Chart in QlikView

Button Macro to Create Variable for Chart

Mon, 26 Jan 2026 18:19:17 GMT

Hi all, I am new to QlikView and have recently run into a problem. In my application, I have a chart similar to the example Google Maps chart that comes standard in QV 9. I would like to create a button that runs a macro to create a variable, which I am then able to call on in the chart expressions (in order to dynamically resize and recolor the dots based on the variable's value created by the button).

Any advice on how to go about this? I'm stumped.

Button Macro to Create Variable for Chart

Fri, 22 Jan 2010 16:42:18 GMT

Hello,

I don't understand your question very well, but if you just want to create a variable:

ActiveDocument.CreateVariable newVar

Set v = ActiveDocument.Variables(newVar)

v.setContent variableContent, true ' variableContent is the formula or expression for your new variable

Steve

Button Macro to Create Variable for Chart

Fri, 22 Jan 2010 17:57:17 GMT

Hi Steve,

Thank you for the response and I apologize for being so confusing. It looks like this is going in the right direction but I still can't get it to work properly. What is "v" in the code? The variables I'm creating are not passing to the chart.

What I would like is this: 1. Button to create a variable called "newVar". Eventually, I want Button2 and Button3 to do the same thing via different formulas.

Button 1 will have:: newVar = sum(Sales) <-- Sales is a field in data table in the sheet, On click it sets and the chart is able to call it to dynamically change.

2. Separate sheet object, a Chart , set to reflect the value of the newVar.

Button Macro to Create Variable for Chart

Fri, 22 Jan 2010 20:26:18 GMT

Hi,

I made an example. It's very simple

If you have any question feel free to ask.

Steve

Button Macro to Create Variable for Chart

Sat, 23 Jan 2010 01:04:32 GMT

Thanks Steve! Solution was perfect.

I might have another question coming soon regarding a button to set a a Year to Date, Week to Date, and Last Week value in separate Year, Week, and Day list boxes but I'm going to give it some more thought first. I really appreciate your help.

~MIchael

Button Macro to Create Variable for Chart

Sat, 23 Jan 2010 01:31:57 GMT

Hey Michael, I forgot to tell you that you have to verify if the variable is already created every time you press the button.

Steve