topic Re: Grouping Values in QlikView

Grouping Values

Anonymous — Wed, 17 Dec 2014 19:04:41 GMT

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

Re: Grouping Values

maxgro — Wed, 17 Dec 2014 19:22:03 GMT

maybe adapting this? (10 instead of 3 class)

Recipe for a Pareto Analysis

Re: Grouping Values

sebastiandperei — Wed, 17 Dec 2014 20:24:37 GMT

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

Re: Grouping Values

Anonymous — Wed, 17 Dec 2014 20:31:01 GMT

That helps. Thank you.