Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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

10 Replies
Anonymous
Not applicable

by using the gauge chart to implement the green and red symbols