topic Re: More than 3 segments for Traffic light gauge representation of Expression in QlikView

More than 3 segments for Traffic light gauge representation of Expression

bhavikumehta — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

Requirement: Show Actual vs Expected results in Traffic light bullets form. There are 4 Segments :

1. if Actual >= Expected then Green (Segment 1)

2. if Actual between Expected and Expected - 9% then Yellow (Segment 2)

3. if Actual < Expected - 9% then Red (Segment 3)

4. if Expected is zero then Grey (Segment 4)

Min and Max values set to -10000 and 10000

Issue: I am getting only 3 colors which i have set for first 3 segments. 4th segment color shows as 3rd segment color.

Am i missing any setting here? Does Traffic light gauge consider only first 3 segment colors? If yes then please suggest alternative to implement above requirement of showing Bullet colors based on different conditions.

Thank you.

Re: More than 3 segments for Traffic light gauge representation of Expression

vishsaggi — Fri, 22 Sep 2017 14:46:56 GMT

May be try like keeping the 4th as 1st like this order?

4. if Expected is zero then Grey (Segment 4)

1. if Actual >= Expected then Green (Segment 1)

2. if Actual between Expected and Expected - 9% then Yellow (Segment 2)

3. if Actual < Expected - 9% then Red (Segment 3)

Re: More than 3 segments for Traffic light gauge representation of Expression

effinty2112 — Fri, 22 Sep 2017 14:56:43 GMT

Hi Bravik,

Try:

Pick(

Match(-1,

Expected = 0,

Actual >= Expected,

Actual >= 0.91*Expected,

-1),

LightGray(), Green(),Yellow(),Red())

Regards

Andrew

Re: More than 3 segments for Traffic light gauge representation of Expression

Peter_Cammaert — Fri, 22 Sep 2017 14:58:56 GMT

Are you defining this gauge as a separate object or as a mini-chart?

Re: More than 3 segments for Traffic light gauge representation of Expression

bhavikumehta — Fri, 22 Sep 2017 15:31:30 GMT

tried re-ordering.. 4th segment color does not show up instead it shows 3rd segment color for 4th segment.

Re: More than 3 segments for Traffic light gauge representation of Expression

bhavikumehta — Fri, 22 Sep 2017 15:32:13 GMT

Are you asking to apply using only 1 segment ?

Re: More than 3 segments for Traffic light gauge representation of Expression

bhavikumehta — Fri, 22 Sep 2017 15:34:58 GMT

Using Traffic light gauge representation for an expression in a Pivot chart

Re: More than 3 segments for Traffic light gauge representation of Expression

vishsaggi — Fri, 22 Sep 2017 15:36:45 GMT

Can you share your expression if possible?

Re: More than 3 segments for Traffic light gauge representation of Expression

vvira1316 — Fri, 22 Sep 2017 16:28:31 GMT

How about following

=If(Expected=0,'qmem://ImageID/Grey',
If(Actual>=Expected, 'qmem://ImageID/Green',
If(Actual < Expected and (Expected-Actual)/Expected*100 <= 9, 'qmem://ImageID/Yellow',
'qmem://ImageID/Red'
)))

instead of image you can use RGB() of each color you want.

Re: More than 3 segments for Traffic light gauge representation of Expression

vvira1316 — Fri, 22 Sep 2017 17:32:19 GMT

This one uses traffic light gauge

=If(Expected=0,0,
If(Actual>=Expected, 1,
If(Actual < Expected and (Expected-Actual)/Expected*100 <= 9, 2,3
)))

gauge segment lower bound setting of 0 (grey), 1 (green), 2 (yellow), 3 (red)