topic Re: Negative limits in traffic light indicator in QlikView

Negative limits in traffic light indicator

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

Hi guys.

I have problems with the semaphore indicator of the simple table.

Insert limits in positive values but in negative ones you can not.

Is there any way to differentiate colors in negative values?

These are the limits that should have on the traffic light indicator.

Green: [from 0% to 5%] and [from 0% to -5%]

Yellow: [> 5% up to 10%] and [<-5% up to -10%]

Red: [> 10%] and [<-10%].

Help me please

Greetings.

I attach the qvw.

Anonymous — Fri, 06 Apr 2018 01:26:02 GMT

I tried a workaround of your problem

i add some hidden field for easy calculation but this is optional.

IND = DIFERENCIA/[JH PRE]

Presentation for this field is hidden

then i used this hidden field to create another calculated field for color coding

if(

(IND >= 0 and IND <=.05) or (IND < 0 and IND >=-.05),0,

if (

(IND >= 0.05 and IND <=.1) or (IND < -0.05 and IND >-.1),5,

10)

)

then i use this on the guage setting for the traffic light.

Nagaraju_KCS — Fri, 06 Apr 2018 03:21:39 GMT

Like this..

cristianj23a — Fri, 06 Apr 2018 12:57:22 GMT

I also did something similar.

Thank you very much.

If(DIFERENCIA/[JH PRE]<=0 and DIFERENCIA/[JH PRE]>=-0.05 or DIFERENCIA/[JH PRE]>=0 and DIFERENCIA/[JH PRE]<=0.05,1,

If(DIFERENCIA/[JH PRE]<=-0.05 and DIFERENCIA/[JH PRE]>=-0.1 or DIFERENCIA/[JH PRE]>=0.05 and DIFERENCIA/[JH PRE]<=0.1,2,

If(DIFERENCIA/[JH PRE]<=-0.1 or DIFERENCIA/[JH PRE]>=0.1 ,3)))

Regards.