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

Announcements
Meet Qlik's New CEO. The Future Is Bright — Here's What to Expect
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
Labels (1)
0 Replies