topic Re: Colors Cells in QlikView https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275448#M579840 <HTML><HEAD></HEAD><BODY><P>Hi Javier,</P><P></P><P>Go to the chart properties, Expression tab and expand using the [+] symbol at the left of the expression "Cantidad Incidentes", select Background color and use this expression:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P class="p1"><SPAN class="s1">If(SecondaryDimensionality() &lt;&gt; 0, If</SPAN>(<SPAN class="s1">ColumnNo</SPAN>() &lt;= <SPAN class="s2">Severity_llamadas</SPAN>, <SPAN class="s1">RGB</SPAN>(<SPAN class="s3">100</SPAN>, <SPAN class="s3">200</SPAN>, <SPAN class="s3">50</SPAN>)))</P></PRE><P></P><P>SecondaryDimensionality() will prevent to color the totals column.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Sat, 14 Jan 2012 02:10:45 GMT Miguel_Angel_Baeyens 2012-01-14T02:10:45Z Colors Cells https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275447#M579839 <HTML><HEAD></HEAD><BODY><P> Hi guys, I need to get some cels iluminated depending the row, I attached the app and an excel pic of how I need it to be.</P><P></P><P>any help would be great!!</P></BODY></HTML> Fri, 13 Jan 2012 17:00:42 GMT https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275447#M579839 2012-01-13T17:00:42Z Re: Colors Cells https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275448#M579840 <HTML><HEAD></HEAD><BODY><P>Hi Javier,</P><P></P><P>Go to the chart properties, Expression tab and expand using the [+] symbol at the left of the expression "Cantidad Incidentes", select Background color and use this expression:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code"><P class="p1"><SPAN class="s1">If(SecondaryDimensionality() &lt;&gt; 0, If</SPAN>(<SPAN class="s1">ColumnNo</SPAN>() &lt;= <SPAN class="s2">Severity_llamadas</SPAN>, <SPAN class="s1">RGB</SPAN>(<SPAN class="s3">100</SPAN>, <SPAN class="s3">200</SPAN>, <SPAN class="s3">50</SPAN>)))</P></PRE><P></P><P>SecondaryDimensionality() will prevent to color the totals column.</P><P></P><P>Hope that helps.</P><P></P><P>Miguel</P></BODY></HTML> Sat, 14 Jan 2012 02:10:45 GMT https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275448#M579840 Miguel_Angel_Baeyens 2012-01-14T02:10:45Z Colors Cells https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275449#M579841 <HTML><HEAD></HEAD><BODY><P>Hi Javier,</P><P></P><P>Use this one in the expression Background Color instead the one you already have.</P><P><BR />Regards.</P><P></P><P>Miguel</P></BODY></HTML> Mon, 16 Jan 2012 15:19:13 GMT https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275449#M579841 Miguel_Angel_Baeyens 2012-01-16T15:19:13Z Colors Cells https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275450#M579842 <HTML><HEAD></HEAD><BODY><P> oook, I get it now, it´s working great, thanks miguel.!!</P></BODY></HTML> Mon, 16 Jan 2012 15:20:41 GMT https://community.qlik.com/t5/QlikView/Colors-Cells/m-p/275450#M579842 2012-01-16T15:20:41Z