topic Re: How to show Contribution in Pie Chart in Qlik View? in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799690#M2465 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P></P><P>Thank you for the solution. I tried it but no luck.</P></BODY></HTML> Tue, 30 Dec 2014 19:27:22 GMT 2014-12-30T19:27:22Z How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799685#M2460 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I am working with <STRONG style="color: #800000;">Qlik View 11 Personal Edition</STRONG> I have the data like this</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>Age Group</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Number of Students</TH></TR><TR><TD style="padding: 2px;">20-22</TD><TD style="padding: 2px;">30</TD></TR><TR><TD style="padding: 2px;">23-25</TD><TD style="padding: 2px;">20</TD></TR><TR><TD style="padding: 2px;">25 and above</TD><TD style="padding: 2px;">50</TD></TR></TBODY></TABLE><P></P><P>Now I want to show a pie chart to represent contribution.</P><P></P><P>i.e., if I select "20-22" from the list box, pie chart should show two parts 20-22 (30%) and Others (70%).</P><P></P><P>I tried "Dimension Limits" by selecting "First" "1" values and "Show Others". But now luck.</P><P></P><P>Any clues?</P></BODY></HTML> Tue, 30 Dec 2014 03:05:59 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799685#M2460 2014-12-30T03:05:59Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799686#M2461 <HTML><HEAD></HEAD><BODY><P>Use alternate states</P></BODY></HTML> Tue, 30 Dec 2014 03:52:39 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799686#M2461 ecolomer 2014-12-30T03:52:39Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799687#M2462 <HTML><HEAD></HEAD><BODY><P>In pie chart your requeriment aren't possible, but yes in pivot table as this:</P><P><IMG alt="p07.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74369_p07.png" style="height: 211px; width: 620px;" /></P></BODY></HTML> Tue, 30 Dec 2014 04:05:30 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799687#M2462 ecolomer 2014-12-30T04:05:30Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799688#M2463 <HTML><HEAD></HEAD><BODY><P>you can store grand total in variable vgtot&nbsp; and use this variable as fourmula&nbsp;&nbsp; no of students/ vgtot&nbsp; in number format choose show in %</P><P></P><P>Hope this helps you</P><P></P><P>Vikas</P></BODY></HTML> Tue, 30 Dec 2014 08:05:55 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799688#M2463 vikasmahajan 2014-12-30T08:05:55Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799689#M2464 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you for the solution. Is it possible to show the totals as percentage?</P></BODY></HTML> Tue, 30 Dec 2014 19:26:02 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799689#M2464 2014-12-30T19:26:02Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799690#M2465 <HTML><HEAD></HEAD><BODY><P>Hi Vikas,</P><P></P><P>Thank you for the solution. I tried it but no luck.</P></BODY></HTML> Tue, 30 Dec 2014 19:27:22 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799690#M2465 2014-12-30T19:27:22Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799691#M2466 <HTML><HEAD></HEAD><BODY><P>You should be able to do this with a Calculated Dim of:</P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; =aggr(if(only({1}[Age Group])=[Age Group],[Age Group],'Others'),[Age Group])</SPAN></P><P></P><P>and an Expression of</P><P><SPAN style="font-family: 'courier new', courier;">&nbsp; sum({1}[Number of Students])</SPAN></P><P>with Relative checked.</P><P></P><P>See attached example.</P><P></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com" rel="nofollow">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://robwunderlich.com" rel="nofollow">http://robwunderlich.com</A></P></BODY></HTML> Tue, 30 Dec 2014 20:57:51 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799691#M2466 rwunderlich 2014-12-30T20:57:51Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799692#M2467 <HTML><HEAD></HEAD><BODY><P>Yes .. <IMG alt="p01.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74429_p01.png" style="height: 281px; width: 620px;" /></P></BODY></HTML> Tue, 30 Dec 2014 21:36:03 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799692#M2467 ecolomer 2014-12-30T21:36:03Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799693#M2468 <HTML><HEAD></HEAD><BODY><P>Hi Ravindra</P><P>I think the following is exactly what you are looking for.</P><P></P><P>Please let me know if you need anything else.</P><P></P><P>Thanks</P><P>Agis</P></BODY></HTML> Wed, 31 Dec 2014 00:09:37 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799693#M2468 Agis-Kalogiannis 2014-12-31T00:09:37Z Re: How to show Contribution in Pie Chart in Qlik View? https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799694#M2469 <HTML><HEAD></HEAD><BODY><P>Thank you so much.</P></BODY></HTML> Wed, 31 Dec 2014 06:40:27 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/How-to-show-Contribution-in-Pie-Chart-in-Qlik-View/m-p/799694#M2469 2014-12-31T06:40:27Z