topic Re: Rank Customers by Profitability in QlikView

Rank Customers by Profitability

Fri, 22 May 2015 13:26:04 GMT

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,

Re: Rank Customers by Profitability

Clever_Anjos — Fri, 22 May 2015 13:33:57 GMT

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

Re: Rank Customers by Profitability

Anonymous — Fri, 22 May 2015 13:35:28 GMT

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.

Re: Rank Customers by Profitability

Fri, 29 May 2015 06:54:25 GMT

So please find attached - I appreciate your assistance.

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

Re: Rank Customers by Profitability

Anonymous — Fri, 29 May 2015 08:04:16 GMT

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

Re: Rank Customers by Profitability

Clever_Anjos — Fri, 29 May 2015 12:52:39 GMT

How negative profit should be handled?