topic create a gauge chart using macro in QlikView

create a gauge chart using macro

Wed, 18 Nov 2015 10:24:36 GMT

Hi,

I want to Create Gauge Chart using macro with min gauge setting to 0.5 and Max Gauge Setting to 1.2 and Segment 2 lowerbond with Expression

Re: create a gauge chart using macro

marcus_sommer — Wed, 18 Nov 2015 14:30:09 GMT

You could create this and adjust the properties with code (examples from APIGuide.qvw) like this:

set Graph = ActiveDocument.Sheets("Main").CreateGaugeChart

Graph.AddExpression "sum(Amount)"

set chart = ActiveDocument.GetSheetObject("CH01")

set gp = chart.GetProperties

set gs = gp.ChartProperties.GaugeSettings.GaugeSegments

for i = 0 to gs.Count-1

gs.Item(i).Name.v = i

chart.SetProperties gp

But why do you want create this per macro? If you need some flexibilities you could use conditions and variables within the chart to meet other requirements.

- Marcus

Re: create a gauge chart using macro

oknotsen — Mon, 25 Jan 2016 10:54:56 GMT

Do not make the same topic multiple times. It is considered spamming.

Create Gauge Chart Using Macro