topic Re: Traffic light indicator in straight table in QlikView

Traffic light indicator in straight table

grajmca_sgp123 — Thu, 09 Jul 2015 17:21:30 GMT

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'15	Q2'15	VPQ
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

Re: Traffic light indicator in straight table

MK_QSL — Thu, 09 Jul 2015 17:40:24 GMT

What is the color criteria?

Re: Traffic light indicator in straight table

Anonymous — Thu, 09 Jul 2015 17:43:47 GMT

Hi,

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

Can you post a qwv sample data?

Regards.

Re: Traffic light indicator in straight table

maxgro — Thu, 09 Jul 2015 17:52:12 GMT

I used

-999 for lower bound of Segment1

-0.05 " Segment2

0.5 " Segment3

also my VPQ is VPQ / 100

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

Re: Traffic light indicator in straight table

grajmca_sgp123 — Thu, 09 Jul 2015 18:07:48 GMT

Hi Here below is the color criteria.

Greater than equal 35 -> Red

Between -20 to 35 -> Yellow

Lessthan equal to -21 -> Green

Re: Traffic light indicator in straight table

MK_QSL — Thu, 09 Jul 2015 18:08:04 GMT

Sample file enclosed....

Re: Traffic light indicator in straight table

grajmca_sgp123 — Thu, 09 Jul 2015 18:09:06 GMT

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

Re: Traffic light indicator in straight table

MK_QSL — Thu, 09 Jul 2015 18:10:01 GMT

Set Min -999 and Max 999

Re: Traffic light indicator in straight table

grajmca_sgp123 — Thu, 09 Jul 2015 18:29:44 GMT

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

Re: Traffic light indicator in straight table

MK_QSL — Thu, 09 Jul 2015 18:31:11 GMT

Please close the thread by selecting appropriate answer..

Re: Traffic light indicator in straight table

Anonymous — Thu, 25 Feb 2016 04:48:36 GMT

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