Single field value in Gauge chart

[#1]

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

[#2]

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

[#3]

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

[#4 · Accepted solution]

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