Accessing document variables in a macro

[#1]

I have some variables on my sheet which I want to use in my VBScript. How can I go about doing this?

Thanks,

T.

[#2]

Check out API guide to access variables into Macro.

QlikView Core COM API Guide - Version 11

[petter · Accepted solution]

You can access a particular variable like this:

	Set Test = Activedocument.Variables("Test")
	MsgBox Test.GetContent.String

[#4]

Hi Petter,

Is there a way to get the dimension that is being used as an axis in a chart? E.g. if I had Date as one of my dimensions could I swap that dimension with the other dimension i.e. swapping the X with the Y axis.

Thanks,

T

[petter]

You still want to do this in a macro right?

[#6]

Yeah ideally, currently what I have is a chart where the dimensions are defined by the user by using conditional expressions however I'm finding that sometimes the chart may look better if the axis are swapped. I currently have a button that does not trigger anything but I was thinking that it can be used to call a VBA module that swaps the axis.

Thanks,

T