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: 
vidhya91gct
Partner - Contributor
Partner - Contributor

Latest month Traffic Light in Chart

Hi All,

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

   

GYR Category Oct 2017Nov 2017Dec 2017Jan 2018Feb 2018Mar 2018
AAA Y - SY - SY - UG - SY - SY-S
BBB Y - SY - UY - DR - UY - D
CCC Y - SG - SG - SG - SG - SG-S
DDD G - SG - SG - SG - SG - S
FFFF Y - SY - DY - DR - DY - DY-S

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)

4 Replies
chinnuchinni
Creator III
Creator III

how did you get the below format ? based on which field you want to display the lights ? the below table for march its showing value for AAA,CCC,FFFF only.

can elaborate your requirement more clearly ?

if it is possible can you attach the sample doc
? so that will easy to resolve the problem to us.

vidhya91gct
Partner - Contributor
Partner - Contributor
Author

I want to show the traffic light based on status

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

GYR CategoryOct 2017Nov 2017Dec 2017Jan 2018Feb 2018Mar 2018
AAAY - SY - SY - UG - SY - SY-S
BBBY - SY - UY - DR - UY - D
CCCY - SG - SG - SG - SG - SG-S
DDDG - SG - SG - SG - SG - S
FFFFY - SY - DY - DR - DY - DY-S

In this table,

G-S - green   , Y-S - yellow ,R-D - Red

i want show the traffic light based on the latest month.


for ex : latest month is Mar 2018 , getting status 'Y-S' , 'G-S','Y-S' , set the the 3 Segment traffic lights.

in the Mar'2018 column i have Yellow and green, so i want to show yellow color traffic light.

Scenerio :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



chinnuchinni
Creator III
Creator III

can you post your app ?

vidhya91gct
Partner - Contributor
Partner - Contributor
Author

Sorry i dont have App, I have attached the above excel file, it is the final format.

I have the file(GYR Catatgory -AAA,BBB),GYR Month - Oct 2017,Nov 2017,Dec 2017,Jan 2018, Feb 2018, Mar 2018)

(GYR Status - Y-S, G-S , Y-S)

Changed to cross table(GYR Month, GYR Status,1) and getting the below format

GYR CategoryOct 2017Nov 2017Dec 2017Jan 2018Feb 2018Mar 2018
AAAY - SY - SY - UG - SY - SY-S
BBBY - SY - UY - DR - UY - D
CCCY - SG - SG - SG - SG - SG-S
DDDG - SG - SG - SG - SG - S
FFFFY - SY - DY - DR - DY - DY-S

I want to show the 3 segment traffic light(Red,yellow and Green).

This 3 segment traffic light is compared with last month data,

i have Yellow and green, want to show yellow color 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