80/20 Analysis in Bar Chart - Qlik Community

dineshsingh · ‎2015-08-23

Hi All,

I've to create a bar chart as shown in the image below:

As displayed the bar chart is county wise. In each bar I have two slice of it: one of these slices will show "No. of customers who're contributing to 80% of sales" while other slice will show remaining customers.

Here, I could not find a working expression which can fulfill my requirement. I tried to search on community but unable to find any working solution.

Edit: I've attached the sample data application.

Any suggestions will be really helpful for me

Regards,

Dinesh

Message was edited by: Dinesh Singh

sunny_talwar · ‎2015-08-23

Would you be able to share some sample data to test out your requirement?

kkkumar82 · ‎2015-08-23

Hi Dinesh,

Hope this may help you.

Recipe for a Pareto Analysis

Thanks

KK

dineshsingh · ‎2015-08-23

Hi Sunny,

Thanks for your valuable suggestion. I've attached the sample data application.

Dinesh

ecolomer · ‎2015-08-23

See this:

Recipe for an ABC Analysis

Recipe for a Pareto Analysis

and files attached

dineshsingh · ‎2015-08-26

Thanks Enrique, but it does not resolve my problem.

dineshsingh · ‎2015-08-26

Unable to find solution to my problem using this link.

Digvijay_Singh · ‎2015-08-26

I cannot view qvw as having personal edition, can you share sample data in excel.

dineshsingh · ‎2015-08-26

Hi Digvijay,

Please find attached CSV file.

Digvijay_Singh · ‎2015-08-27

Hi Dinesh,

Could you manage to do it as It seems to be difficult task in Qlik?

I found very good article of troyansky explaining the complexity and the solution using alternate state.

http://www.naturalsynergies.com/q-tip-11-so-how-many-customers-make-up-most-of-your-sales/

I tried to implement using your data but don't think I achieved it completely as count is not coming 100% correct.

See if it can help you to improve further. I suggest first go through the link to understand the process.