topic Re: traffic light in straight table in QlikView

traffic light in straight table

suryaa30 — Wed, 25 Nov 2020 16:16:04 GMT

in below table i would want Amber if CY-PY=0 and GREEN if CY-PY>0 and RED if CY-PY<0

there should be only one light and not three. as in if its green then the other two greys should not be there. single circle.

What should the expression be and what should the gauge settings be? I am not aware of the bounds in gauge settings.

And can we bring the traffic light next to a value and not as a separate column?

Re: traffic light in straight table

vishsaggi — Sat, 09 Sep 2017 18:12:01 GMT

Are you looking for something like this?

Re: traffic light in straight table

maxgro — Sat, 09 Sep 2017 18:39:23 GMT

try to check the gauge properties,

Indicator Mode

Segments Setup

Re: traffic light in straight table

suryaa30 — Sat, 09 Sep 2017 18:42:32 GMT

‌yes

Re: traffic light in straight table

vishsaggi — Sat, 09 Sep 2017 18:47:31 GMT

May be helpful read Here: Gauges – QLIKIES

Using inbuilt LED images would be better option to show this traffic light display. use something like this:

Expression for Growth

= IF(CY/PY = 0.00, 'qmem://<bundled>/BuiltIn/led_o.png', IF(CY/PY > 0.00,'qmem://<bundled>/BuiltIn/led_g.png', IF(CY/PY < 0.00, 'qmem://<bundled>/BuiltIn/led_r.png')))

Re: traffic light in straight table

suryaa30 — Sun, 10 Sep 2017 05:36:09 GMT

IS IT POSSIBLE TO MAKE A SELECTION ON THE TRAFFIC LIGHT SOMEHOW? For example i click on red and all related red are selected? also can i merge the value and the light together? the last two columns

Re: traffic light in straight table

vishsaggi — Sun, 10 Sep 2017 15:56:17 GMT

Unfortunately we do not have that facility to have value and Led Light in the same column coz if you see below we can select only one of them from the display options, i doubt if we have that option, hence new column.

Re: traffic light in straight table

vishsaggi — Sun, 10 Sep 2017 16:39:18 GMT

Ok may be you can create a flag in your script like

load *, IF(CY/PY = 0.00, 1, IF(CY/PY > 0.00, 2, IF(CY/PY < 0.0, 3))) AS ColorFlag inline [

Retendor, CY, PY

A,12,0

B,0,8

C,4,4

D,4,3

E,6,9

F,8,3

G,4,7

H,1,-4

];

Then use this color flag in a list box like below:

Add a dimension as expression

= Pick(Match(ColorFlag, 1, 2, 3), 'qmem://<bundled>/BuiltIn/led_o.png', 'qmem://<bundled>/BuiltIn/led_g.png', 'qmem://<bundled>/BuiltIn/led_r.png')

In Presentation tab Image Options select Image as representation and Image Formatting as Keep Aspect. You will have like this: