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: 
Not applicable

Need help to show traffic light gauge charts


Hi ,

I am new to Qlikview. I am trying to design a Traffic Light Gauge chart and show Green , Yellow and Reg lights based on the one of the column values (Business_sourced/Rejection score). below is my data source. I selected region as dimesion and in expression i used this condition

If (Business_sourced>=50,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

but no data is displayed . Can some one help me how to design and show the Traffic Gauge Lights chart

CityRegionBusiness sourcedBad qualityRejection score
MumbaiWest130107.70%
PuneWest5024.00%
IndoreWest600.63.00%
KolkataEast10077.00%
BurdwanEast150.21.30%
RanchiEast6037.50%
DelhiNorth1502013.30%
GurgaonNorth600.51.30%
ChandigarhNorth5012.00%
AmritsarNorth100.77.00%
BangaloreSouth9044.40%
ChennaiSouth9533.20%
MysoreSouth6012.50%
7 Replies
simospa
Partner - Specialist
Partner - Specialist

Hi,

in Chart Properties --> Expressions --> [choose the expression you want to be a traffic light gauge] and in Dispay Options  --> Representation --> Traffic Light Gauge.

S.

krishna20
Specialist II
Specialist II

Hi,

Please refer this link.It may helps you

How to use a Linear gauge

Regards

Krishna

simsondevadoss
Partner - Creator III
Partner - Creator III

Need to select representation as image under display options after giving the conditions

chrislofthouse
Partner Ambassador
Partner Ambassador

If you have a copy we can take a look. If there are multiple values for 'Business_sourced' for each dimension you will need to wrap a function around it e.g. SUM()

If (SUM(Business_sourced)>=50,'qmem://<bundled>/BuiltIn/led_g.png','qmem://<bundled>/BuiltIn/led_r.png')

Not applicable
Author

Thanks All , It worked finally changed the display options  represenation property to image.

simospa
Partner - Specialist
Partner - Specialist

You're welcome.

Consider to mark as useful the answers you think help you

Bye

S.

Anonymous
Not applicable
Author

Hi Simone,

I have a similar requirement. As an example, I have created a straight table taking Business area as dimension. I have an in which we are calcualting service avaibility and in assigning the colour to the result as below.
If Service Availability % >95, GREEn Colour,
If service availability % >75 and <95, AMBER colour,
if service availability % <75, RED colour.
Now i am using a gauge chart(in form of traffic light) in which i want to show below details.

Red >2 services statistics breaching their SLA targets
Amber 1-2 services YTD statistics breaching their SLA targets
Green  No services  YTD statistics breaching their SLA targets

Please help me how can we show this in Traffic signal chart.

Regards
Bibhu