Pie chart - display as doughnut

[#1]

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

[Gysbert_Wassenaar]

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

[rwunderlich]

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

[#4]

yes this is very helpful and works fine for me...

Many Thanks

[#5]

Hi Gysbert,

What is ChartMode for Mekko chart type in Qlikview 11?

Any idea???

Thanks

Preeti

[#6]

Hi Gysbert,

What is ChartMode for Mekko chart type in Qlikview 11?

Any idea???

Thanks

Preeti