topic Re: Single field value in Gauge chart in QlikView

Single field value in Gauge chart

Mon, 12 May 2014 10:34:13 GMT

Hi all,

I have an aggregated table with aggregate on various data.

one of the fields is a calculation of some percentage.

I want to show this value in a Gauge chart, when the whole scale is 100% and the cross points at the percentage of the value.

Can it be done?

Thanks,

Boris

Re: Single field value in Gauge chart

Mon, 12 May 2014 10:40:25 GMT

Go to presentation tab of Gauge chart and define segments. In your case you need only on segemnt.

Then put your expression on Expression Tab.

It should work.

Regards

Darek

Re: Single field value in Gauge chart

Mon, 12 May 2014 10:47:12 GMT

and how can I rotate the boundaries between the ref and the green segments?

Re: Single field value in Gauge chart

Mon, 12 May 2014 10:54:02 GMT

Boris,

i'am not sure if i understand your needs, but:

Lower Bound

Specifies the gauge value where the selected segment starts. If the Autowidth Segments option is deselected (see below) this text box is enabled to edit the numerical value of the lower limit of the selected segment here. If the Relative Segment Bounds option is selected (see below) the segment bounds should be entered as numbers between 0 and 1, indicating a fraction of the total range between the Min and Max values.

You may attach sample data in excel and show me (in excel) how your chart should look like for those data and i will try to support creation of it in QlikView

regards

Darek