Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jsingh71
Valued Contributor

Issue on Fast change Chart Type.

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.

2 Replies
Not applicable

Re: Issue on Fast change Chart Type.

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

jaryszek2
Contributor

Re: Issue on Fast change Chart Type.

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

Community Browser