Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear experts..
I am looking to have a report create like below..
slab | No. of Custid | Orders | Price |
Top 10% Customers | 10000 | 10000 | 2000 |
Next 10% Customers | 9000 | 12000 | 100 |
Next 20% Customers | 16200 | 150000 | 30000 |
Next 30% Customers | 19440 | 13000 | 200 |
Rest 30% | 45360 | 13000 | 100 |
What is need is out of 1,00,000 customer, they are to be divided into various slabs like above.
Is this possible.?
Thank you!
Sean.
Do you have a sample app?
slab | No. of Custid | Orders | Price |
Top 10% Customers | 10000 | 10000 | 2000 |
Next 10% Customers | 9000 | 12000 | 100 |
Next 20% Customers | 16200 | 150000 | 30000 |
Next 30% Customers | 19440 | 13000 | 200 |
Rest 30% | 45360 | 13000 | 100 |
Why the third customer with 150k orders and buying the most expensive items is considered as next 20% of customers?
Sean, the best I have are the following link that may be of some use for some ideas in addition to what Arthur posted.
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497
Not sure if this will work or not, but figured I would toss it over for you to check out.
Regards,
Brett
Do you have a sample app?
slab | No. of Custid | Orders | Price |
Top 10% Customers | 10000 | 10000 | 2000 |
Next 10% Customers | 9000 | 12000 | 100 |
Next 20% Customers | 16200 | 150000 | 30000 |
Next 30% Customers | 19440 | 13000 | 200 |
Rest 30% | 45360 | 13000 | 100 |
Why the third customer with 150k orders and buying the most expensive items is considered as next 20% of customers?
Sean, the best I have are the following link that may be of some use for some ideas in addition to what Arthur posted.
https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-a-Pareto-Analysis/ba-p/1468497
Not sure if this will work or not, but figured I would toss it over for you to check out.
Regards,
Brett