Grouping Values

[Anonymous]

I have a table that contains a customer number and a customer balance.  Is there a way to show the number of customers that have the top 10% of balances followed by the next 10% etc.?

I am not sure how to code this in the QlikView expression.

Any help would be appreciated.

Thanks,

Ed T

[maxgro]

maybe adapting this? (10 instead of 3 class)

Recipe for a Pareto Analysis

[sebastiandperei · Accepted solution]

Dimmention:

Round(

     Aggr(Sum(Balance_field),Customer_field)/

     Sum(Total Balance_field),

          0.1)

Expression:

Count (Distinct Customer_field)

If you cant do it, please, send the reduced qvw

[Anonymous]

That helps.  Thank you.