topic Disabling 'Others' within Pie Charts in QlikView

Disabling 'Others' within Pie Charts

Dayna — Tue, 01 Jun 2010 13:20:29 GMT

Hello,

Is it possible, to remove the 'Others' group within Pie Charts - I am currently using a Pie chart to show the top 5 customers on Sales, but as we have more than 5 customers I automatically get the 'Others' segment..

Any help with the above would be most appreciated!!!

Kind Regards,
Dayna

Disabling 'Others' within Pie Charts

Tue, 01 Jun 2010 13:55:46 GMT

You can limited a number of slice of pie chart on the properties.....and not show another values after most 5 customers os Sales.

Disabling 'Others' within Pie Charts

Dayna — Tue, 01 Jun 2010 14:12:30 GMT

Hello Erico,

Many thanks for your fast reply, but unfortunately that is what I've already done - but all other customers get placed under 'Other's. Which I don't want to display...

Disabling 'Others' within Pie Charts

quwok — Tue, 01 Jun 2010 16:37:11 GMT

Hi Dayna,

not sure if a pie chart is the best chart, as pie charts are used to display ratios of the whole. a horizontal bar chart would be an easier option, you can simply sort by their ranking and set the 'Max Visible Number' to 5 on the 'Presentation' tab.

if you are going the pie chart way, your best bet would be to use set analysis to reduce your data set to the top 5 customers. the rank() function should help you identify the top 5. may i refer you to the following post for details.

Disabling 'Others' within Pie Charts

Tue, 01 Jun 2010 18:43:16 GMT

Maybe you can configure the limit area of slice of pie chart in presentation.....did you try that?