topic Re: Change Color on Pie Chart that is calculation in QlikView https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4211#M646 <HTML><HEAD></HEAD><BODY><P>You are not getting this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190784_Capture.PNG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Sun, 21 Jan 2018 05:16:40 GMT Anil_Babu_Samineni 2018-01-21T05:16:40Z Change Color on Pie Chart that is calculation https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4207#M642 <HTML><HEAD></HEAD><BODY><P>How can i change the color on the pie chart , where and how I would put the calculation. </P><P>I can change the colors in colors mode. but the colors do not always stay there. I would like to hardcode as shown but the calculation is not working.</P><P></P><P>Can someone please help. </P></BODY></HTML> Sun, 21 Jan 2018 01:51:21 GMT https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4207#M642 Anonymous 2018-01-21T01:51:21Z Re: Change Color on Pie Chart that is calculation https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4208#M643 <HTML><HEAD></HEAD><BODY><P>May be try this for your measure Background from Expansion + symbol</P><P></P><P><STRONG>If(Aggr(FirstSortedValue(DISTINCT [Inherent Risk],-Level),[Seller Symbol],Sector)='High', Green(),</STRONG></P><P><STRONG>If(Aggr(FirstSortedValue(DISTINCT [Inherent Risk],-Level),[Seller Symbol],Sector)='Low', Red(),</STRONG></P><P><STRONG>If(Aggr(FirstSortedValue(DISTINCT [Inherent Risk],-Level),[Seller Symbol],Sector)='Medium', LightCyan(),</STRONG></P><P><STRONG>LightMagenta())))</STRONG></P></BODY></HTML> Sun, 21 Jan 2018 02:29:17 GMT https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4208#M643 Anil_Babu_Samineni 2018-01-21T02:29:17Z Re: Change Color on Pie Chart that is calculation https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4209#M644 <HTML><HEAD></HEAD><BODY><P>anil babu can i get your email. </P></BODY></HTML> Sun, 21 Jan 2018 04:53:41 GMT https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4209#M644 Anonymous 2018-01-21T04:53:41Z Re: Change Color on Pie Chart that is calculation https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4210#M645 <HTML><HEAD></HEAD><BODY><P>No, the data is not loading correctly,</P><P></P><P>Please answer using this updated QV Document</P><P></P><P>!</P></BODY></HTML> Sun, 21 Jan 2018 05:01:23 GMT https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4210#M645 Anonymous 2018-01-21T05:01:23Z Re: Change Color on Pie Chart that is calculation https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4211#M646 <HTML><HEAD></HEAD><BODY><P>You are not getting this?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/190784_Capture.PNG" style="max-width: 620px; height: auto;" /></P></BODY></HTML> Sun, 21 Jan 2018 05:16:40 GMT https://community.qlik.com/t5/QlikView/Change-Color-on-Pie-Chart-that-is-calculation/m-p/4211#M646 Anil_Babu_Samineni 2018-01-21T05:16:40Z