topic Re: Issue on Fast change Chart Type. in QlikView

Issue on Fast change Chart Type.

jsingh71 — Fri, 04 Jan 2013 06:47:44 GMT

I have created one Pie chart and select 3 more chart type Bar, Line and Pivot as Fast change.

Now is there any way available every time when user comes on this tab by default chart always show as a Pie chart.

Fri, 11 Jan 2013 14:12:03 GMT

try to use macro (on sheet activate)

sub SetAsPieChart

set chart = ActiveDocument.GetSheetObject("CH01")

chart.SetChartType 1

end sub

below extended list of all types :

Bar 0

Pie 1

Pivot 2

Scatter 6

Line 4

Straight Table 5

Anonymous — Thu, 17 Mar 2016 08:50:19 GMT

Hi,

I would like to join to this discussion,

where from can i take list of types of all charts?

It is any documentation or can i get this from VBA ?

Please help,

Best Regards,

Jacek Antek