80/20 Analysis in Bar Chart

[dineshsingh]

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]

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

[kkkumar82]

Hi Dinesh,

Hope this may help you.

Recipe for a Pareto Analysis

Thanks

KK

[dineshsingh]

Hi Sunny,

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

Dinesh

[ecolomer]

See this:

Recipe for an ABC Analysis

Recipe for a Pareto Analysis

and files attached

[dineshsingh]

Thanks Enrique, but it does not resolve my problem.

[dineshsingh]

Unable to find solution to my problem using this link.

[Digvijay_Singh]

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

[dineshsingh]

Hi Digvijay,

Please find attached CSV file.

[Digvijay_Singh]

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.