Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rank Customers by Profitability

Hi everyone,

I am trying to rank my customer base to determine who is the top 10% of my customer base.

I have to calculate the profit field by adding the income generated per customer and subtracting the costs per customer.

The problem is that all of the solutions I have come across thus far has been based on the dimension and I need to be able to rank the customers based on a calculated expression..

I hope you can assist me.

Thank you,

L

5 Replies
Clever_Anjos
Employee
Employee

Would you mind sharing some data? https://community.qlik.com/docs/DOC-1290

Anonymous
Not applicable
Author

Have a look at the Dimension Limits tab of your Chart.

<Tick> Restrict which values are displayed using fthe first expression and set the setting below that

You'll need to make sure that your first expression is indeed the Profit expression.

Not applicable
Author

So please find attached - I appreciate  your assistance.

I have made a fake qlikview but I believe the same principles apply

Anonymous
Not applicable
Author

create a calculated dimension using =num(aggr(sum(Income),CustID)-(aggr( sum(Expense),CustID)),'############.')

then use this dimension to limit the dimension using Dimension Limits

Thanks

BKC

Clever_Anjos
Employee
Employee

How negative profit should be handled?