topic Traffic Light Formula in QlikView https://community.qlik.com/t5/QlikView/Traffic-Light-Formula/m-p/212910#M66761 <HTML><HEAD></HEAD><BODY><P>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%.</P><P>The table is below. Can someone help me with the correct logic?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="236"><COL style="width: 48pt;" width="64" /><COL style="width: 129pt;" width="172" /><TBODY><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; width: 48pt;" width="64">Color</TD><TD style="width: 129pt;" width="172">Count(Color)/Count(total)</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Green</TD><TD align="right">0.31</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Yellow</TD><TD align="right">0.37</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Red</TD><TD align="right">0.31</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 11 Feb 2011 14:15:20 GMT 2011-02-11T14:15:20Z Traffic Light Formula https://community.qlik.com/t5/QlikView/Traffic-Light-Formula/m-p/212910#M66761 <HTML><HEAD></HEAD><BODY><P>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%.</P><P>The table is below. Can someone help me with the correct logic?</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="236"><COL style="width: 48pt;" width="64" /><COL style="width: 129pt;" width="172" /><TBODY><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt; width: 48pt;" width="64">Color</TD><TD style="width: 129pt;" width="172">Count(Color)/Count(total)</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Green</TD><TD align="right">0.31</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Yellow</TD><TD align="right">0.37</TD></TR><TR height="20" style="height: 15pt;"><TD height="20" style="height: 15pt;">Red</TD><TD align="right">0.31</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 11 Feb 2011 14:15:20 GMT https://community.qlik.com/t5/QlikView/Traffic-Light-Formula/m-p/212910#M66761 2011-02-11T14:15:20Z