topic Re: 80/20 Analysis in Bar Chart in QlikView

80/20 Analysis in Bar Chart

dineshsingh — Sun, 23 Aug 2015 17:05:44 GMT

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

Re: 80/20 Analysis in Bar Chart

sunny_talwar — Sun, 23 Aug 2015 17:07:39 GMT

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

Re: 80/20 Analysis in Bar Chart

kkkumar82 — Sun, 23 Aug 2015 17:13:08 GMT

Hi Dinesh,

Hope this may help you.

Recipe for a Pareto Analysis

Thanks

Re: 80/20 Analysis in Bar Chart

dineshsingh — Sun, 23 Aug 2015 17:25:44 GMT

Hi Sunny,

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

Dinesh

Re: 80/20 Analysis in Bar Chart

ecolomer — Sun, 23 Aug 2015 18:20:16 GMT

See this:

Recipe for an ABC Analysis

Recipe for a Pareto Analysis

and files attached

Re: 80/20 Analysis in Bar Chart

dineshsingh — Wed, 26 Aug 2015 08:23:24 GMT

Thanks Enrique, but it does not resolve my problem.

Re: 80/20 Analysis in Bar Chart

dineshsingh — Wed, 26 Aug 2015 08:24:15 GMT

Unable to find solution to my problem using this link.

Re: 80/20 Analysis in Bar Chart

Digvijay_Singh — Wed, 26 Aug 2015 08:28:18 GMT

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

Re: 80/20 Analysis in Bar Chart

dineshsingh — Wed, 26 Aug 2015 08:35:14 GMT

Hi Digvijay,

Please find attached CSV file.

Re: 80/20 Analysis in Bar Chart

Digvijay_Singh — Thu, 27 Aug 2015 21:10:16 GMT

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.

Re: 80/20 Analysis in Bar Chart

Oleg_Troyansky — Fri, 28 Aug 2015 17:17:05 GMT

Hi Digvijay‌, thanks for mentioning my blog.

I'm not too sure if my method can be used here. It depends on the nature of the question. Since the required chart is plotted by Country, two possible questions can be asked here:

1. In each country, how many customers make up 80% of total Sales in the same country?

2. How many customers in each country belong to the global group of customers that make up 80% of my total sales globally.

Using the method that I described in my blog, we can answer the second question, but we can't answer the first question. At the moment, I can't think of a solution that would work well for the first question.

cheers,

Oleg Troyansky

QlikView Your Business: An expert guide to Business Discovery with QlikView and Qlik Sense

Re: 80/20 Analysis in Bar Chart

Digvijay_Singh — Mon, 31 Aug 2015 05:30:14 GMT

Thanks troyansky‌ for clarifying on this, I guess first question is asked here.

dineshsingh‌ Please confirm.