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

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
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