topic table background coloring based on the value in QlikView https://community.qlik.com/t5/QlikView/table-background-coloring-based-on-the-value/m-p/857797#M530181 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have again a question or problem and hope somebody can help.</P><P>I have created a straight table which is somehow dynamically, this means the user can choose dimensions and expressions by himself and the straight table will be updated. i want now to color the background according the value of the table, but i dont want to use the formula behind, because this formula is somehow complicate because of the dynamic calculation. Is there a possibility to color it automatically based on the calue of each cell?</P><P></P><P>i would like to define ranges like</P><P></P><P>If(cellvalue&lt;0.7,RGB(165,0,38),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue&lt;0.9</SPAN>,RGB(217,239,139),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue</SPAN>&lt;1.0,RGB(102,189,99),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue</SPAN>&lt;1.1,RGB(244,109,67),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue</SPAN>&lt;1.5,RGB(253,174,97),If(cellvalue&gt;=1.5,RGB(0,104,55)))))))</P><P></P><P>thanks, armin</P></BODY></HTML> Mon, 13 Jul 2015 07:50:34 GMT 2015-07-13T07:50:34Z table background coloring based on the value https://community.qlik.com/t5/QlikView/table-background-coloring-based-on-the-value/m-p/857797#M530181 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have again a question or problem and hope somebody can help.</P><P>I have created a straight table which is somehow dynamically, this means the user can choose dimensions and expressions by himself and the straight table will be updated. i want now to color the background according the value of the table, but i dont want to use the formula behind, because this formula is somehow complicate because of the dynamic calculation. Is there a possibility to color it automatically based on the calue of each cell?</P><P></P><P>i would like to define ranges like</P><P></P><P>If(cellvalue&lt;0.7,RGB(165,0,38),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue&lt;0.9</SPAN>,RGB(217,239,139),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue</SPAN>&lt;1.0,RGB(102,189,99),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue</SPAN>&lt;1.1,RGB(244,109,67),If(<SPAN style="font-size: 13.3333330154419px;">cellvalue</SPAN>&lt;1.5,RGB(253,174,97),If(cellvalue&gt;=1.5,RGB(0,104,55)))))))</P><P></P><P>thanks, armin</P></BODY></HTML> Mon, 13 Jul 2015 07:50:34 GMT https://community.qlik.com/t5/QlikView/table-background-coloring-based-on-the-value/m-p/857797#M530181 2015-07-13T07:50:34Z