Help with aggregation for PARETO analysis

Tue, 29 Dec 2009 23:28:03 GMT

Hi,

I'm making an analysis on customermix and would like to show the % share of total revenue that the top ten customers represent each month.

It indicates how well diversified our customer portfolio is and how it evolves in time.

So in the X axis I want to show the Months and in the Y axis a % share

In the excel file attached I try to show you what I need.

I manage to calculate the % share of top 10 customer revenue compared to total customer revenue but I don't succeed in varying it by month (e.g. value by month) in one chart.

Has anyone done similar analysis or has any suggestions?

Thanks,

Help with aggregation for PARETO analysis

Thu, 31 Dec 2009 21:29:47 GMT

Hi,

You can do it using some functions. The proper synthax to find the TOP 10 customer by month is to create a new dimension as :

=if(aggr( rank( sum(Revenu)) , Month , Customer) <= 10 , Customer,null())

See the example (but only with the TOP2). The data are your data, except one row where I changed a value to have customer C ahead in march.

I add a button with Pareto analysis which could be useful for you. In my example, i select the customer who made 50% of the overall revenu.

Happy new year

topic Help with aggregation for PARETO analysis in QlikView

Help with aggregation for PARETO analysis

Help with aggregation for PARETO analysis