Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Traffic Light Formula

I am trying for change the color of a traffic light via formula. I had Qlikview create a pivot table of my data. I need to have the color change in the light to red if the red "percent" is greater than or equal to 25%.

The table is below. Can someone help me with the correct logic?

ColorCount(Color)/Count(total)
Green0.31
Yellow0.37
Red0.31
0 Replies