topic Re: Double/ triple... pie chart in QlikView

Double/ triple... pie chart

Mon, 23 Jun 2014 11:11:18 GMT

Dear qlikview community,

I have a table containing a company, customer, and amount. For each company, i would like a pie chart ring with the top 5 customers. How can i archieve this? The same as with a stacked bar chart actually thus.

Thanks in advance

Re: Double/ triple... pie chart

MK_QSL — Mon, 23 Jun 2014 11:18:04 GMT

Create a pie chart

Dimension

=IF(Aggr(Rank(SUM(Sales),4),Customer)<=3, Customer)

Tick Suppress When Value is NULL

Company

Expression

SUM(Sales)

Re: Double/ triple... pie chart

ashfaq_haseeb — Mon, 23 Jun 2014 11:22:51 GMT

Hi,

Look at the attached document

Regards

ASHFAQ

Re: Double/ triple... pie chart

Mon, 23 Jun 2014 11:43:07 GMT

set parameters (top 5) in tab "dimension limits"

best regards

Chris

Re: Double/ triple... pie chart

Mon, 23 Jun 2014 12:15:23 GMT

Although usefull, it's not what i need. I need PIE RINGS (e.g. Menagerie Mind: March 2010) surrounding each other but showing the same info as STACKED BAR CHARTS.

Re: Re: Double/ triple... pie chart

ashfaq_haseeb — Mon, 23 Jun 2014 16:03:21 GMT

Hi, In that case look at the attached application.

Regards

ASHFAQ