topic Re: Traffic Light Gauge in QlikView

Traffic Light Gauge

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

Hi Guys,

I have been struggling to create a Traffic light gauge in a straight table.

What I would like to have, is a traffic light indicating the below.

IF([Variance]<0,RED()

IF([Variance] >0 and [Variance] <1,YELLOW()

IF([Variance]>1 , GREEN())

Variance the label name for an expression which calculates the variance between actual and budget values. I get an error when creating a IF statement like the above, saying that there's an invalid token.

Nonetheless, I would really love to just have a 3 segment traffic light gauge, where the colours are based on the above.

Can anyone please assist?

Kind regards,

Re: Traffic Light Gauge

vinieme12 — Wed, 06 Sep 2017 07:34:26 GMT

try below expression

IF([Variance]>1 , GREEN()

,IF([Variance]<0,RED(),Yellow() ) )

Re: Traffic Light Gauge

effinty2112 — Wed, 06 Sep 2017 08:06:02 GMT

Hi Ruan,

Here's an alternative to nested ifs that I think is easier to read but it's really just a matter of taste.

Pick(

Match(

-1,

[Variance]<0,

[Variance]<1,

-1),

Red(),

Yellow(),

Green())

Cheers

Andrew