Rank Customers by Profitability

[#1]

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

[Clever_Anjos]

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

[Anonymous]

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.

[#4]

So please find attached - I appreciate  your assistance.

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

[Anonymous]

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]

How negative profit should be handled?