topic Colors in straight table based on expressions in QlikView https://community.qlik.com/t5/QlikView/Colors-in-straight-table-based-on-expressions/m-p/411056#M1151095 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a straight table and I want a column to get a color based on an espression:</P><P>column "Valore unitario" has to become yellow when the value is lower than the espression max(total Importo/Quantita) , i.e. the value is lower than the maximum value in the column.</P><P></P><P>The max value in the column in 0,1380.&nbsp;&nbsp; So all the values below that level should be yellow.&nbsp;&nbsp; In this case on the contrary I get some cells with maximum value 0,1380 that become yellow. Can anyone tell me why?</P><P></P><P>Please see attached file.</P><P>Thank you.</P></BODY></HTML> Mon, 29 Apr 2013 19:26:46 GMT 2013-04-29T19:26:46Z Colors in straight table based on expressions https://community.qlik.com/t5/QlikView/Colors-in-straight-table-based-on-expressions/m-p/411056#M1151095 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have a straight table and I want a column to get a color based on an espression:</P><P>column "Valore unitario" has to become yellow when the value is lower than the espression max(total Importo/Quantita) , i.e. the value is lower than the maximum value in the column.</P><P></P><P>The max value in the column in 0,1380.&nbsp;&nbsp; So all the values below that level should be yellow.&nbsp;&nbsp; In this case on the contrary I get some cells with maximum value 0,1380 that become yellow. Can anyone tell me why?</P><P></P><P>Please see attached file.</P><P>Thank you.</P></BODY></HTML> Mon, 29 Apr 2013 19:26:46 GMT https://community.qlik.com/t5/QlikView/Colors-in-straight-table-based-on-expressions/m-p/411056#M1151095 2013-04-29T19:26:46Z Re: Colors in straight table based on expressions https://community.qlik.com/t5/QlikView/Colors-in-straight-table-based-on-expressions/m-p/411057#M1151096 <HTML><HEAD></HEAD><BODY><P>Could be a rounding issue. If Importo isn't exactly 1.738,80 but 1.738,999999...etc then the result of division by 12.600 isn't exactly 0,1380 but 0,137999999...etc</P></BODY></HTML> Tue, 30 Apr 2013 07:56:56 GMT https://community.qlik.com/t5/QlikView/Colors-in-straight-table-based-on-expressions/m-p/411057#M1151096 Gysbert_Wassenaar 2013-04-30T07:56:56Z