Discussion Board for collaboration related to QlikView App Development.
I try to make a macro to change the look of a gauge chart. I tried this, but it's nok working:
set chart = ActiveDocument.GetSheetObject("GaugeChart") set prop = chart.GetProperties prop.GaugeChartMode =0 chart.SetProperties prop
It generates an error on the line prop.gaugechartmode=0. Do you have any idea why it's not working?
this should work.
set chart = ActiveDocument.GetSheetObject("GaugeChart")
set prop = chart.GetProperties
set gProp = prop.ChartProperties
gProp.GaugeChartMode = 0
View solution in original post
This works like a charm. Thanks a lot