topic Re: How to add colours ? in QlikView https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429396#M808970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>if( sum(Sales)&gt;150,Green(),&nbsp; if(sum(Sales)&lt;80,Red()))</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180823_Capture.JPG" style="height: 242px; width: 620px;" /></P></BODY></HTML> Wed, 25 Oct 2017 07:36:49 GMT devarasu07 2017-10-25T07:36:49Z How to add colours ? https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429393#M808967 <HTML><HEAD></HEAD><BODY><P>The below table shows product sales .</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 1</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">Product</TD><TD style="padding: 2px;">Sales</TD></TR><TR><TD style="padding: 2px;">Car</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">Fridge</TD><TD style="padding: 2px;">50</TD></TR><TR><TD style="padding: 2px;">Television</TD><TD style="padding: 2px;">200</TD></TR><TR><TD style="padding: 2px;">WashingMachine</TD><TD style="padding: 2px;">70</TD></TR></TBODY></TABLE><P></P><P>How can i achieve this ?</P><P></P><P>sales &gt; 150 is to be shown in Green</P><P>sales &lt; 80 is to be shown in Red&nbsp; ???</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429393#M808967 ramcena306 2020-11-25T16:16:04Z Re: How to add colours ? https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429394#M808968 <HTML><HEAD></HEAD><BODY><P>Hi Ramesh</P><P></P><P>In your chart use&nbsp; Properties&gt;Visual Cues like below</P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180830_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Wed, 25 Oct 2017 07:28:53 GMT https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429394#M808968 cristinapo 2017-10-25T07:28:53Z Re: How to add colours ? https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429395#M808969 <HTML><HEAD></HEAD><BODY><P>You can use BG color like</P><P><STRONG>If(Sum(Sales) &gt; 150, Green(), If(Sum(Sales) &lt; 80, Red()))</STRONG></P></BODY></HTML> Wed, 25 Oct 2017 07:29:40 GMT https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429395#M808969 Anil_Babu_Samineni 2017-10-25T07:29:40Z Re: How to add colours ? https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429396#M808970 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>if( sum(Sales)&gt;150,Green(),&nbsp; if(sum(Sales)&lt;80,Red()))</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/180823_Capture.JPG" style="height: 242px; width: 620px;" /></P></BODY></HTML> Wed, 25 Oct 2017 07:36:49 GMT https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429396#M808970 devarasu07 2017-10-25T07:36:49Z Re: How to add colours ? https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429397#M808971 <HTML><HEAD></HEAD><BODY><P>Thank You <A href="https://community.qlik.com/qlik-users/205546">devarasu07</A> R</P></BODY></HTML> Wed, 25 Oct 2017 08:23:55 GMT https://community.qlik.com/t5/QlikView/How-to-add-colours/m-p/1429397#M808971 ramcena306 2017-10-25T08:23:55Z