topic Re: Accessing document variables in a macro in QlikView

Accessing document variables in a macro

Wed, 20 Jan 2016 16:26:08 GMT

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

Thanks,

Re: Accessing document variables in a macro

Wed, 20 Jan 2016 17:00:30 GMT

Check out API guide to access variables into Macro.

QlikView Core COM API Guide - Version 11

Re: Accessing document variables in a macro

petter — Wed, 20 Jan 2016 17:01:27 GMT

You can access a particular variable like this:

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

Re: Accessing document variables in a macro

Thu, 21 Jan 2016 10:35:49 GMT

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,

Re: Accessing document variables in a macro

petter — Thu, 21 Jan 2016 14:57:31 GMT

You still want to do this in a macro right?

Re: Accessing document variables in a macro

Thu, 21 Jan 2016 15:06:28 GMT

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,