Negative limits in traffic light indicator

[cristianj23a]

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]

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.

[qv_testing · Accepted solution]

Like this..

[cristianj23a]

Hi qv_testing.

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.