Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
can someone please help.
we've created a chart object in a document (Qlikview 11) and have set it to type "Pie Chart".
We're now trying to programmatically set the look of this chart to doughnut via a macro.
If you look at the attached file, this is an easy task via the property panel (Style tab, Look section).
But how would we go about doing this in a macro ?
I've not been able to find any settings to do this.
Any ideas ? Would appreciate guidance on this.
Thanks
Preeti
Use the PieChartMode method of the ChartProperties object:
set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties
p.ChartProperties.PieChartMode = 3
chart.SetProperties p
Pie chart look
0 = 2D
1 = 3D
2 = Thin donut
3 = Normal donut
4 = Thick donut
A gentle reminder that SetProperties is not supported on the Server. If this document is going to be deplyed on Server, I'd recommend you take a different approach.
-Rob
yes this is very helpful and works fine for me...
Many Thanks
Hi Gysbert,
What is ChartMode for Mekko chart type in Qlikview 11?
Any idea???
Thanks
Preeti
Hi Gysbert,
What is ChartMode for Mekko chart type in Qlikview 11?
Any idea???
Thanks
Preeti