topic Re: expression display as traffic light in QlikView

expression display as traffic light

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

Need to represent the expressions in the graphic that I have attached like traffic light gauge with 3 segments (red, yellow and green).

For example, first expresion (Q1_J) value will be:

Red: if Q1_J <avg(Q1_J) of all employees with same value in field “pto”

Yellow: if Q1_J =avg(Q1_J) of all employees with same value in field “pto”

Green: if Q1_J >avg(Q1_J) of all employees with same value in field “pto”

Regards

sunny_talwar — Fri, 22 Jun 2018 12:33:47 GMT

Like this?

=If(Q1_J < Avg(TOTAL <pto> [J_I1]), LightRed(),

If(Q1_J = Avg(TOTAL <pto> [J_I1]), Yellow(), LightGreen()))

vvira1316 — Fri, 22 Jun 2018 12:51:39 GMT

expression for avg

Avg(TOTAL <pto> [J_I1])

Light Value setting

if ([J_I1] < Avg(TOTAL <pto> [J_I1]), -1,
if ([J_I1] = Avg(TOTAL <pto> [J_I1]), 0, 1))

gauge setting Min = -1, Max = 1

Red for -1, Yellow for 0 and green for 1

Uncheck autosegment

eva_maria — Fri, 22 Jun 2018 13:18:22 GMT

Hi! Vijay, that's perfect, exactly what I was looking for.

Thanks for your invaluable help and for your time

regards.

eva_maria — Fri, 22 Jun 2018 13:23:27 GMT

Hi Sunny.

I appreciate your answer because I didn't know the way that you proposed

Thaks for your help and your time

Regards