topic multiple rank in a pie chart in QlikView

multiple rank in a pie chart

Wed, 14 Oct 2009 21:15:24 GMT

Can we have multiple rank in a pie chart?

for example, I like to have top 10 customers and 11-20 customers on pie chart with $amount and percentage.

I know how to get top 10 customer with rank and aggr but i can't figure out having both in one chart.

Thanks!

multiple rank in a pie chart

rwunderlich — Wed, 14 Oct 2009 23:17:07 GMT

Will setting the "Maximum Number of Slices" (in Presentation) to 10 give you what you need?

-Rob

multiple rank in a pie chart

Wed, 14 Oct 2009 23:22:21 GMT

yes, it is the easiest way to get only top 10, but I need top 10 customers in one slice of pie and top 11-20 customers in another slice and Others in third slice.

Ryan

multiple rank in a pie chart

prieper — Thu, 15 Oct 2009 03:48:01 GMT

Should work with a calculated dimension like the below (aircode - not tested)

IF(AGGR(RANK(SUM(Turnover)), Customer) < 10, Customer, IF(AGGR(RANK(SUM(Turnover)), Customer) < 20, 'Customer 11-20', 'Others'))

HTH
Peter

multiple rank in a pie chart

Thu, 15 Oct 2009 04:42:46 GMT

Thanks!