Sort auto generated group others in pie chart

[#1]

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).

Example:

• Others 0%
• Group 2 40%
• Group 1 30%
• Group 4 10%
• Group 5 5%
• Group 3 5

Thanks in advance!

[Anonymous]

I don't think it is possible. You may want to send a feature request to QlikTech

[prieper]

Hi,

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.

HTH

Peter

[Anonymous]

Peter,
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.

[#5]

Hi Peter,

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!

[prieper · Accepted solution]

Hi,

now with attachment

/Peter

[stephencredmond]

Or maybe just don't use pie charts!

http://www.perceptualedge.com/articles/visual_business_intelligence/save_the_pies_for_dessert.pdf

Stephen

[prieper]

Hi Stephan

Fully agree, but this kind of solution works also for bar-charts (actually prefer for the ranking the vertical bars

/Peter

[#9]

Thanks Peter!

[#10]

Thanks for sharing Stephen. Some nice insightsI posted it on http://www.quickqlearqool.nl/?p=669