Circular Gauge Chart with Equal Segments

Fri, 02 Dec 2016 13:06:08 GMT

HI,

I need to create a circular gauge chart split into 6 equal segments. I then need to colour each of these segments Red, Green or White depending on the following calculation

Segment1 :

=if(sum(Segment1)/(sum(total_assessments)*2)=1,rgb(0,255,0),

if(sum(Segment1)/(sum(total_assessments)*2)>1,rgb(255,000,0),

if(sum(Segment1)/(sum(total_assessments)*2)<1,white())))

Segment2 :

=if(sum(Segment2 )/(sum(total_assessments)*2)=1,rgb(0,255,0),

if(sum(Segment2 )/(sum(total_assessments)*2)>1,rgb(255,000,0),

if(sum(Segment2)/(sum(total_assessments)*2)<1,white())))

... and so on for all six segments.

is this possible ??

many thanks!

Re: Circular Gauge Chart with Equal Segments

sunny_talwar — Fri, 02 Dec 2016 16:28:25 GMT

Do you have a sample of where you stand right now? May be we can play around with what you have to get you to what you want

topic Re: Circular Gauge Chart with Equal Segments in QlikView

Circular Gauge Chart with Equal Segments

Re: Circular Gauge Chart with Equal Segments