Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Grouping Values

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

1 Solution

Accepted Solutions
sebastiandperei
Specialist
Specialist

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

View solution in original post

3 Replies
maxgro
MVP
MVP

maybe adapting this? (10 instead of 3 class)

Recipe for a Pareto Analysis

sebastiandperei
Specialist
Specialist

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
Not applicable
Author

That helps.  Thank you.