topic Re: Colors based on Value in QlikView https://community.qlik.com/t5/QlikView/Colors-based-on-Value/m-p/948208#M528552 <HTML><HEAD></HEAD><BODY><P>You might have created a duplicate thread: <A href="https://community.qlik.com/thread/177027">Colors based on Value</A></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I think you should be able to do this for Text Color Expression:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">If(YourSalesExpression &lt;= 40, Red(), If(</STRONG><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><STRONG style="font-style: inherit; font-size: 13.3333320617676px; font-family: inherit;">YourSalesExpression &lt;=70, Green(), Blue()))</STRONG></SPAN></P></BODY></HTML> Wed, 19 Aug 2015 06:37:50 GMT sunny_talwar 2015-08-19T06:37:50Z Colors based on Value https://community.qlik.com/t5/QlikView/Colors-based-on-Value/m-p/948207#M528551 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi All,</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">I have the following data in My table. Can we display Sales background color like</P><P style="font-size: 13.3333330154419px;"><STRONG>10-40 red</STRONG></P><P style="font-size: 13.3333330154419px;"><STRONG>50-70 Green</STRONG></P><P style="font-size: 13.3333330154419px;"><STRONG>80-100 Blue</STRONG></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Year&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P style="font-size: 13.3333330154419px;">2005&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">10</SPAN></P><P style="font-size: 13.3333330154419px;">2006&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;"> 20</SPAN></P><P style="font-size: 13.3333330154419px;">2007&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">30&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P style="font-size: 13.3333330154419px;">2008&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff0000;">40</SPAN></P><P style="font-size: 13.3333330154419px;">2009&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #008000;"> 50</SPAN></P><P style="font-size: 13.3333330154419px;">2010&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #008000;">60</SPAN></P><P style="font-size: 13.3333330154419px;">2011&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #008000;">70</SPAN></P><P style="font-size: 13.3333330154419px;">2012&nbsp;&nbsp;&nbsp; <SPAN style="color: #ff00ff;"> <SPAN style="color: #0000ff;">80</SPAN></SPAN></P><P style="font-size: 13.3333330154419px;">2013&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;">90</SPAN></P><P style="font-size: 13.3333330154419px;">2014&nbsp;&nbsp;&nbsp; <SPAN style="color: #0000ff;">100</SPAN></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Regards</P><P style="font-size: 13.3333330154419px;">Sharath</P></BODY></HTML> Wed, 19 Aug 2015 06:35:58 GMT https://community.qlik.com/t5/QlikView/Colors-based-on-Value/m-p/948207#M528551 2015-08-19T06:35:58Z Re: Colors based on Value https://community.qlik.com/t5/QlikView/Colors-based-on-Value/m-p/948208#M528552 <HTML><HEAD></HEAD><BODY><P>You might have created a duplicate thread: <A href="https://community.qlik.com/thread/177027">Colors based on Value</A></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I think you should be able to do this for Text Color Expression:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG style="font-style: inherit; font-family: inherit;">If(YourSalesExpression &lt;= 40, Red(), If(</STRONG><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: inherit;"><STRONG style="font-style: inherit; font-size: 13.3333320617676px; font-family: inherit;">YourSalesExpression &lt;=70, Green(), Blue()))</STRONG></SPAN></P></BODY></HTML> Wed, 19 Aug 2015 06:37:50 GMT https://community.qlik.com/t5/QlikView/Colors-based-on-Value/m-p/948208#M528552 sunny_talwar 2015-08-19T06:37:50Z