https://community.qlik.com/t5/QlikView/Color-Coding-for-the-Summary/m-p/1796718#M1211324 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/41787">@Zhandos_Shotan</a>&nbsp;,,</P><P>&nbsp;</P><P>I got the result earlier&nbsp; but&nbsp; not getting like.. as shown in the screenshot (Color Coding)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lakshmanvepuri_0-1617464873431.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52319i44FC2BA98AF1CE4C/image-size/medium?v=v2&amp;px=400" role="button" title="lakshmanvepuri_0-1617464873431.png" alt="lakshmanvepuri_0-1617464873431.png" /></span></P><P>Thanks</P><P>Vepuri</P> Sat, 03 Apr 2021 15:48:18 GMT lakshmanvepuri 2021-04-03T15:48:18Z https://community.qlik.com/t5/QlikView/Color-Coding-for-the-Summary/m-p/1796648#M1211308 <P>Hi Gurus,&nbsp;</P><P>&nbsp;</P><P>Please let me know how do I achieve this.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>SPEND</P></TD><TD><P>119000</P></TD><TD><P>90040</P></TD></TR><TR><TD><P>Budget</P></TD><TD><P>100000</P></TD><TD><P>100000</P></TD></TR><TR><TD><P>Diff</P></TD><TD><P><FONT color="#FF0000">[</FONT>19000<FONT color="#FF0000">]</FONT></P></TD><TD><P><FONT color="#00FF00">[</FONT>9960<FONT color="#00FF00">]</FONT></P></TD></TR><TR><TD>&nbsp;</TD><TD><P><FONT color="#FF0000"><STRONG>+19%</STRONG></FONT></P></TD><TD><P><STRONG><FONT color="#00FF00">-10%</FONT></STRONG></P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>•For spend</P><P>-<FONT color="#FF0000">Red</FONT> if value <U>exceeds</U> budget, indicating overspend</P><P>-<FONT color="#00FF00">Green</FONT> if value <U>doesn’t exceed</U></P><P>Note:</P><P>Summary tab to show the percentage and actual values that exceed or below target.</P><P>Text and color&nbsp;coding should follow exactly like shown above.</P><P>&nbsp;</P><P>Thanks a lot.</P><P>Regards</P><P>Vepuri</P><P>&nbsp;</P> Fri, 02 Apr 2021 16:37:39 GMT https://community.qlik.com/t5/QlikView/Color-Coding-for-the-Summary/m-p/1796648#M1211308 lakshmanvepuri 2021-04-02T16:37:39Z https://community.qlik.com/t5/QlikView/Color-Coding-for-the-Summary/m-p/1796701#M1211321 <P>Hi!</P><P>Use cell text color expression:</P><P>If([SPEND]/[BUDGET]-1&gt;0, Red(), Green())</P> Sat, 03 Apr 2021 05:54:07 GMT https://community.qlik.com/t5/QlikView/Color-Coding-for-the-Summary/m-p/1796701#M1211321 Zhandos_Shotan 2021-04-03T05:54:07Z https://community.qlik.com/t5/QlikView/Color-Coding-for-the-Summary/m-p/1796718#M1211324 <P>Hi&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/41787">@Zhandos_Shotan</a>&nbsp;,,</P><P>&nbsp;</P><P>I got the result earlier&nbsp; but&nbsp; not getting like.. as shown in the screenshot (Color Coding)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lakshmanvepuri_0-1617464873431.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/52319i44FC2BA98AF1CE4C/image-size/medium?v=v2&amp;px=400" role="button" title="lakshmanvepuri_0-1617464873431.png" alt="lakshmanvepuri_0-1617464873431.png" /></span></P><P>Thanks</P><P>Vepuri</P> Sat, 03 Apr 2021 15:48:18 GMT https://community.qlik.com/t5/QlikView/Color-Coding-for-the-Summary/m-p/1796718#M1211324 lakshmanvepuri 2021-04-03T15:48:18Z