topic Re: Pie chart with Parts and Total in QlikView https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29406#M4893 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_304932_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205237_QlikCommunity_Thread_304932_Pic1.JPG" style="height: auto; width: auto;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/205244_QlikCommunity_Thread_304932_Pic2.JPG" style="height: 248px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic3.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/205245_QlikCommunity_Thread_304932_Pic3.JPG" style="height: 512px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic4.JPG" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/205246_QlikCommunity_Thread_304932_Pic4.JPG" style="height: 202px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic5.JPG" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/205247_QlikCommunity_Thread_304932_Pic5.JPG" style="height: 205px; width: 620px;" /></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 14 Jun 2018 20:44:05 GMT MarcoWedel 2018-06-14T20:44:05Z Pie chart with Parts and Total https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29405#M4892 <HTML><HEAD></HEAD><BODY><P>Let's say if I had a QVD:</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"></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">X</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Y</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Z</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">ALL</TH></TR><TR><TD style="padding: 2px; text-align: center;">A</TD><TD style="padding: 2px; text-align: center;">4</TD><TD style="padding: 2px; text-align: center;">6</TD><TD style="padding: 2px; text-align: center;">4</TD><TD style="padding: 2px; text-align: center;">14</TD></TR><TR><TD style="padding: 2px; text-align: center;">B</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">10</TD><TD style="padding: 2px; text-align: center;">3</TD><TD style="padding: 2px; text-align: center;">20</TD></TR><TR><TD style="padding: 2px; text-align: center;">C</TD><TD style="padding: 2px; text-align: center;">1</TD><TD style="padding: 2px; text-align: center;">0</TD><TD style="padding: 2px; text-align: center;">2</TD><TD style="padding: 2px; text-align: center;">3</TD></TR><TR><TD style="padding: 2px; text-align: center;">D</TD><TD style="padding: 2px; text-align: center;">20</TD><TD style="padding: 2px; text-align: center;">4</TD><TD style="padding: 2px; text-align: center;">5</TD><TD style="padding: 2px; text-align: center;">29</TD></TR><TR><TD style="padding: 2px; text-align: center;">E</TD><TD style="padding: 2px; text-align: center;">0</TD><TD style="padding: 2px; text-align: center;">6</TD><TD style="padding: 2px; text-align: center;">7</TD><TD style="padding: 2px; text-align: center;">13</TD></TR></TBODY></TABLE><P>I want to create a Pie Chart that show how much <STRONG>X</STRONG>, <STRONG>Y</STRONG> and <STRONG>Z</STRONG> represents the <STRONG>ALL</STRONG> field. All the examples that I see, exist a field set in dimension with the values that become the legend of the chart, but in this case the legend has to be X, Y and Z. What I put in <STRONG>dimension</STRONG> and the <STRONG>expression</STRONG>?</P></BODY></HTML> Thu, 14 Jun 2018 16:25:45 GMT https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29405#M4892 Anonymous 2018-06-14T16:25:45Z Re: Pie chart with Parts and Total https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29406#M4893 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>one solution might be:</P><P></P><P><IMG alt="QlikCommunity_Thread_304932_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205237_QlikCommunity_Thread_304932_Pic1.JPG" style="height: auto; width: auto;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic2.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/205244_QlikCommunity_Thread_304932_Pic2.JPG" style="height: 248px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic3.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/205245_QlikCommunity_Thread_304932_Pic3.JPG" style="height: 512px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic4.JPG" class="image-4 jive-image" src="https://community.qlik.com/legacyfs/online/205246_QlikCommunity_Thread_304932_Pic4.JPG" style="height: 202px; width: 620px;" /></P><P><IMG alt="QlikCommunity_Thread_304932_Pic5.JPG" class="image-5 jive-image" src="https://community.qlik.com/legacyfs/online/205247_QlikCommunity_Thread_304932_Pic5.JPG" style="height: 205px; width: 620px;" /></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Thu, 14 Jun 2018 20:44:05 GMT https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29406#M4893 MarcoWedel 2018-06-14T20:44:05Z Re: Pie chart with Parts and Total https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29407#M4894 <HTML><HEAD></HEAD><BODY><P>Why all the labels when you stand the mouse shows <STRONG>X</STRONG>, even in Y or Z values?</P></BODY></HTML> Fri, 15 Jun 2018 18:41:45 GMT https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29407#M4894 Anonymous 2018-06-15T18:41:45Z Re: Pie chart with Parts and Total https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29408#M4895 <HTML><HEAD></HEAD><BODY><P>I can't reproduce this behaviour:</P><P></P><P><IMG alt="QlikCommunity_Thread_304932_Pic6.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/205379_QlikCommunity_Thread_304932_Pic6.JPG" style="height: auto; width: auto;" /></P></BODY></HTML> Fri, 15 Jun 2018 18:53:41 GMT https://community.qlik.com/t5/QlikView/Pie-chart-with-Parts-and-Total/m-p/29408#M4895 MarcoWedel 2018-06-15T18:53:41Z