topic Re: Color the expression according the value in QlikView https://community.qlik.com/t5/QlikView/Color-the-expression-according-the-value/m-p/1184031#M383304 <HTML><HEAD></HEAD><BODY><P>Try something like this</P><P></P><P><STRONG>If(Sum(Sales) = 100, LightRed(), If(Sum(Sales) = 200, ...., LightGreen()))</STRONG></P><P></P><P>OR Please post sample application</P></BODY></HTML> Wed, 14 Sep 2016 15:49:16 GMT Anil_Babu_Samineni 2016-09-14T15:49:16Z Color the expression according the value https://community.qlik.com/t5/QlikView/Color-the-expression-according-the-value/m-p/1184029#M383302 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P>I have a straight table where I have a dimension-Store_Name</P><P>Expressions-Sales/margin/Net Sale Qty </P><P>whenever a measure will be selected the chart will represent the bottom stores based on the measures value-i-e the stores will be sorted in the ascending order.</P><P>Now my problem is that I want to color the most bottom store as the darkest color,the color will be lighter when the stores values will be increasing gradually.i-e-If the bottom stores have values 100,200,300,400,500...then 100 will be darkest red,200 will be a little bit lighter,and so on..</P><P>Please help.</P></BODY></HTML> Wed, 14 Sep 2016 12:04:50 GMT https://community.qlik.com/t5/QlikView/Color-the-expression-according-the-value/m-p/1184029#M383302 2016-09-14T12:04:50Z Re: Color the expression according the value https://community.qlik.com/t5/QlikView/Color-the-expression-according-the-value/m-p/1184030#M383303 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-17002">Using ColorMix In Qlikview</A></P></BODY></HTML> Wed, 14 Sep 2016 15:46:47 GMT https://community.qlik.com/t5/QlikView/Color-the-expression-according-the-value/m-p/1184030#M383303 MK9885 2016-09-14T15:46:47Z Re: Color the expression according the value https://community.qlik.com/t5/QlikView/Color-the-expression-according-the-value/m-p/1184031#M383304 <HTML><HEAD></HEAD><BODY><P>Try something like this</P><P></P><P><STRONG>If(Sum(Sales) = 100, LightRed(), If(Sum(Sales) = 200, ...., LightGreen()))</STRONG></P><P></P><P>OR Please post sample application</P></BODY></HTML> Wed, 14 Sep 2016 15:49:16 GMT https://community.qlik.com/t5/QlikView/Color-the-expression-according-the-value/m-p/1184031#M383304 Anil_Babu_Samineni 2016-09-14T15:49:16Z