Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
maybe adapting this? (10 instead of 3 class)
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
That helps. Thank you.