topic coloring the cell with the first occurrence value in QlikView https://community.qlik.com/t5/QlikView/coloring-the-cell-with-the-first-occurrence-value/m-p/761052#M270760 <HTML><HEAD></HEAD><BODY><P>Hello got a pivot table</P><P>I have an expression that displays a ratio shown in percent</P><P>I want to color the first cell that has the value &gt;=50%</P><P>how can I attain this?</P><P>Please advise</P></BODY></HTML> Fri, 20 Feb 2015 11:19:11 GMT ali_hijazi 2015-02-20T11:19:11Z coloring the cell with the first occurrence value https://community.qlik.com/t5/QlikView/coloring-the-cell-with-the-first-occurrence-value/m-p/761052#M270760 <HTML><HEAD></HEAD><BODY><P>Hello got a pivot table</P><P>I have an expression that displays a ratio shown in percent</P><P>I want to color the first cell that has the value &gt;=50%</P><P>how can I attain this?</P><P>Please advise</P></BODY></HTML> Fri, 20 Feb 2015 11:19:11 GMT https://community.qlik.com/t5/QlikView/coloring-the-cell-with-the-first-occurrence-value/m-p/761052#M270760 ali_hijazi 2015-02-20T11:19:11Z Re: coloring the cell with the first occurrence value https://community.qlik.com/t5/QlikView/coloring-the-cell-with-the-first-occurrence-value/m-p/761053#M270761 <HTML><HEAD></HEAD><BODY><P>With something like =If( ExpressionValue &gt;= 0.5 and above(ExpressionValue) &lt;0.5, color(1) )</P></BODY></HTML> Fri, 20 Feb 2015 11:33:39 GMT https://community.qlik.com/t5/QlikView/coloring-the-cell-with-the-first-occurrence-value/m-p/761053#M270761 Gysbert_Wassenaar 2015-02-20T11:33:39Z