topic Re: Latest month traffic light in QlikView

Latest month traffic light

vidhya91gct — Tue, 20 Mar 2018 06:30:06 GMT

Hi All,

I want to show the latest month state with the following logic for traffic light.

G If all green, = traffic light is green

Y If no red, but any yellow, then traffic light is yellow

R If any red, traffic light is red

for Ex: latest month is Mar2018 and it is Y and G , so i want to show Y (yellow traffic light)

Please find the attached table.

Qrishna — Tue, 20 Mar 2018 07:00:37 GMT

Wheres the file?

krishna20 — Tue, 20 Mar 2018 07:01:47 GMT

Hi Vidhya,

you missed the attachment. Pls share it. Is there any scenario that you will get any G- Y or Y- R or G- R

vidhya91gct — Tue, 20 Mar 2018 08:02:38 GMT

I am getting same format excel file and loaded it.

Catagory GYR Month Status

AAA Oct 2018 G - S

BBBB Nov 2018 Y - D

CCC Dec 2018 R - D

DDD Jan 2018 G -D

EEE Feb2018 Y - S

FFF Mar 2018 R - D it is source format.

I have changed the Pivot table and getting in the below format

I want to show the latest month state with the following logic for traffic light.

G If all green, = traffic light is green

Y If no red, but any yellow, then traffic light is yellow

R If any red, traffic light is red

for Ex: latest month is Mar2018 and it is Y and G , so i want to show Y (yellow traffic light)