topic Sort auto generated group others in pie chart in QlikView https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148587#M26858 <HTML><HEAD></HEAD><BODY><P>I'm wondering if it is possible to sort the auto generated group others on top in the legenda? (for example when you have 5 values but only 10 pie charts you get a group others).</P><P>Example:</P><UL><LI>Others 0%</LI><LI>Group 2 40%</LI><LI>Group 1 30%</LI><LI>Group 4 10%</LI><LI>Group 5 5%</LI><LI>Group 3 5</LI></UL><P>Thanks in advance!</P><P></P><P></P><P></P></BODY></HTML> Mon, 06 Jul 2009 18:17:45 GMT 2009-07-06T18:17:45Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148587#M26858 <HTML><HEAD></HEAD><BODY><P>I'm wondering if it is possible to sort the auto generated group others on top in the legenda? (for example when you have 5 values but only 10 pie charts you get a group others).</P><P>Example:</P><UL><LI>Others 0%</LI><LI>Group 2 40%</LI><LI>Group 1 30%</LI><LI>Group 4 10%</LI><LI>Group 5 5%</LI><LI>Group 3 5</LI></UL><P>Thanks in advance!</P><P></P><P></P><P></P></BODY></HTML> Mon, 06 Jul 2009 18:17:45 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148587#M26858 2009-07-06T18:17:45Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148588#M26859 <HTML><HEAD></HEAD><BODY><P>I don't think it is possible. You may want to send a feature request to QlikTech</P></BODY></HTML> Mon, 06 Jul 2009 23:28:20 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148588#M26859 Anonymous 2009-07-06T23:28:20Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148589#M26860 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>the attached uses a kind of manipulation of the dimension and then works with a sorting by text - agree with Michael, that there is no built-in-functionality.</P><P>HTH</P><P>Peter</P></BODY></HTML> Tue, 07 Jul 2009 05:10:54 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148589#M26860 prieper 2009-07-07T05:10:54Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148590#M26861 <HTML><HEAD></HEAD><BODY><P>Peter,<BR />Your attachment didn't get through, but your hint is good enough. I guess a calcualted dimension can be used for this purpose, in combination with sorting order.</P></BODY></HTML> Tue, 07 Jul 2009 07:10:57 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148590#M26861 Anonymous 2009-07-07T07:10:57Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148591#M26862 <HTML><HEAD></HEAD><BODY><P>Hi Peter,</P><P>Thanks for your reply. Could you please attache the attached file again ;-).. I don't know what you exactly mean with 'a kind of manipulation of the dimension'. Thanks!</P></BODY></HTML> Tue, 07 Jul 2009 14:24:20 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148591#M26862 2009-07-07T14:24:20Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148592#M26863 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>now with attachment</P><P></P><P>/Peter</P></BODY></HTML> Tue, 07 Jul 2009 18:16:58 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148592#M26863 prieper 2009-07-07T18:16:58Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148593#M26864 <HTML><HEAD></HEAD><BODY><P>Or maybe just don't use pie charts!</P><P><A href="http://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf">http://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf</A></P><P></P><P><IMG alt="Big Smile" src="http://community.qlik.com/emoticons/emotion-2.gif" /></P><P>Stephen</P></BODY></HTML> Tue, 07 Jul 2009 18:36:49 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148593#M26864 stephencredmond 2009-07-07T18:36:49Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148594#M26865 <HTML><HEAD></HEAD><BODY><P>Hi Stephan</P><P>Fully agree, but this kind of solution works also for bar-charts (actually prefer for the ranking the vertical bars</P><P>/Peter</P></BODY></HTML> Thu, 09 Jul 2009 03:34:35 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148594#M26865 prieper 2009-07-09T03:34:35Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148595#M26866 <HTML><HEAD></HEAD><BODY><P>Thanks Peter!</P></BODY></HTML> Thu, 09 Jul 2009 13:00:55 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148595#M26866 2009-07-09T13:00:55Z Sort auto generated group others in pie chart https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148596#M26867 <HTML><HEAD></HEAD><BODY><P>Thanks for sharing Stephen. Some nice insightsI posted it on http://www.quickqlearqool.nl/?p=669</P></BODY></HTML> Thu, 09 Jul 2009 16:15:16 GMT https://community.qlik.com/t5/QlikView/Sort-auto-generated-group-others-in-pie-chart/m-p/148596#M26867 2009-07-09T16:15:16Z