topic Chart Continuous X-Axis Macro in QlikView

Chart Continuous X-Axis Macro

Thu, 18 Nov 2010 05:55:20 GMT

Hi All,

Basically what i am trying to do is have a macro execute that changes the chart properties to make the x-axis of the chart continuous or not continuous. The code i was trying to use is below but i haven't been able to find anything in the API that suggests the proper syntax.

sub test

if ActiveDocument.Variables("vCheck").GetContent.String = "YearMonth" then

set chart = ActiveDocument.GetSheetObject("CH382").GetProperties

chart.ChartProperties.(?????) = (True or False I'm guessing??)

chart.SetProperties chart

end if

end sub

I could be going about this the wrong way but i can't really thing of any other way to do it.

Any help would be much appreciated.

-Nick

Chart Continuous X-Axis Macro

Fri, 19 Nov 2010 05:55:59 GMT

bump

Chart Continuous X-Axis Macro

Wed, 01 Jun 2011 14:25:09 GMT

Hi Nick, did you find the answer to this question? I'm looking for the exact same setting ... No joy so far.

Thanks.

Chart Continuous X-Axis Macro

Thu, 09 Jun 2011 15:23:52 GMT

Hi,

Took me a while but I finally found it:

chart.ChartProperties.NumericX = True

Have a great day.