Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
grajmca_sgp123
Creator
Creator

Traffic light indicator in straight table

Hi Experts,

I am trying to design a Traffic Light Gauge chart and show Green , Yellow and Red lights based on the VPQ field. below is my data source.I know the properties where we can create Traffic Light signals. 

in Chart Properties --> Expressions -->  Dispay Options  --> Representation --> Traffic Light Gauge.

but I am unable to set the min and max values for negative and positive values.

Q1'15Q2'15VPQ
Critical
702         149,012.00         297,171.00 99%Red indicator
701           40,334.46         163,359.00 305%RED indicator
711         758,563.64         746,340.86 -2%Yellow indicator
712         256,640.84         288,912.64 13%Yellow indicator
Component
501     2,190,832.00         133,596.00 -94%green indicator
502   (2,727,808.04)        (24,504.00)-99%green
702   26,813,560.37      3,026,948.03 -89%green
701   11,552,657.65      2,179,616.26 -81%green
711     3,973,379.22         727,615.97 -82%green
712     4,141,657.84         900,335.75 -78%green

Can you please suggest how we can set min and max values to get respective traffic light indicators.

Thanks in advance

1 Solution

Accepted Solutions
maxgro
MVP
MVP

I used

-999          for lower bound of Segment1

-0.05         " Segment2

0.5            " Segment3

also my VPQ is VPQ / 100

1.png

but this is just an example to get the output you want

11.png

View solution in original post

10 Replies
MK_QSL
MVP
MVP

What is the color criteria?

Anonymous
Not applicable

Hi,

when the traffic light should be red/Yellow/green?

Can you post a qwv sample data?

Regards.

maxgro
MVP
MVP

I used

-999          for lower bound of Segment1

-0.05         " Segment2

0.5            " Segment3

also my VPQ is VPQ / 100

1.png

but this is just an example to get the output you want

11.png

grajmca_sgp123
Creator
Creator
Author

Hi Here below is the color criteria.

Greater than equal 35     -> Red

Between -20  to   35    -> Yellow

Lessthan equal  to -21 -> Green

MK_QSL
MVP
MVP

Sample file enclosed....

grajmca_sgp123
Creator
Creator
Author

Thank you but i did not get succeeded what is the min and max you set it?

MK_QSL
MVP
MVP

Set Min -999 and Max 999

grajmca_sgp123
Creator
Creator
Author

Thank you all finally understand the logic and implemented it correctly .

MK_QSL
MVP
MVP

Please close the thread by selecting appropriate answer..