Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Negative limits in traffic light indicator

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?

Captura.PNG

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.

1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

3 Replies
Highlighted
Creator
Creator

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.

Capture_1335950.JPG

Capture1_1335950.JPG

Highlighted
Specialist II
Specialist II

Highlighted
Partner
Partner

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.