Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All fellow Qlik users,
I have a set of KPI's that require to be graded in the traditional Red, Yellow, Green traffic light system.
My KPI's are:
<80% - RED
>=80% but <100% - YELLOW
>=100% - GREEN
I can get 2 parameters working OK (Red, Green) using the following expression
if(sum([Completed]/[Target])<0.8,'red',if(sum([Completed]/[Target])>=1,'green'))
I am struggling to work out how to put the "Yellow" section in the middle
Can anyone please help with a solution.
Many thanks in advance,
David
Hi, you can assume that if i't not red or green it should be yellow:
if(sum([Completed]/[Target])<0.8,'red',if(sum([Completed]/[Target])>=1,'green','yellow'))
Or add the check:
if(sum([Completed]/[Target])<0.8,'red',if(sum([Completed]/[Target])<1,'yellow',if(sum([Completed]/[Target])>=1,'green')))
Thanks for the reply - it works as I need it to.
Hi, you can assume that if i't not red or green it should be yellow:
if(sum([Completed]/[Target])<0.8,'red',if(sum([Completed]/[Target])>=1,'green','yellow'))
Or add the check:
if(sum([Completed]/[Target])<0.8,'red',if(sum([Completed]/[Target])<1,'yellow',if(sum([Completed]/[Target])>=1,'green')))
Thanks for the reply - it works as I need it to.