topic Regarding 80/20 output in QlikView

Regarding 80/20 output

qliksus — Tue, 27 Apr 2010 11:36:36 GMT

Hi,

I want to do a pareto chart based on 80/20 .Requirement is ,when i select pareto button one chart will top 80% customer and second chart will show the Bottom 20% .I am able to get only top 80% in the chart by doing pareto select in add action, but Bottom 20% is not coming. Can anyone help me to get the solution??????

I am attached the file.

Waiting for reply.

Regarding 80/20 output

Tue, 27 Apr 2010 19:36:15 GMT

I'm not sure the solution it's what you want.

To display the bottom 20%, you can add 2 actions :

- selection the top 80% as you did

- then add in your button a second action "Select Exluded" using Name as field

look at the attachment

Regarding 80/20 output

qliksus — Wed, 28 Apr 2010 06:58:04 GMT

Hi,

Thnks for reply. I think it will suite to mine reuirement.

Regarding 80/20 output

Wed, 28 Apr 2010 07:42:07 GMT


Jean-Jacques Jesua wrote:
I am not too sure what it does can please explain what this chart does. As I need to check whether it suits some where for my document as well. <div></div>

Regarding 80/20 output

Wed, 28 Apr 2010 11:43:44 GMT

Hi rikab,

The pareto selection is very useful to select your best customer in a database.

In the example, we have customer and for each we know the sale.

The pareto button action select the biggest customer who made 80% of the overall sales.

For the 20% flop, i suggest to use a button with 2 actions (1 = select the top 80%, 2 = inverted the selection).

Hope it helps you

jjj

Regarding 80/20 output

qliksus — Mon, 03 May 2010 08:30:14 GMT

Hi,

I don't want to click on the button to see Pareto Output. I want 2 different charts one will show the Top 80 % and second will show the Bottom 20 %. Can you give some idea how to do it???????

Regarding 80/20 output

Mon, 03 May 2010 17:57:59 GMT

I created in your example 2 chart (the top 80% & the flop 20%).

Click in the 80% button and you have the 2 charts

For the flop, i only use : Sum( {1-$} sale )

But i suspect, you don't want button, just to display the top/flop inside the chart ? I think it's more complicated...

jjj

Regarding 80/20 output

johnw — Mon, 03 May 2010 22:42:56 GMT

Depending on what you mean by "top 80%", you could do this:

Top 80%: if(sum(Sale)> fractile(total aggr(sum(Sale),Name),.2),sum(Sale))
Bottom 20%: if(sum(Sale)<=fractile(total aggr(sum(Sale),Name),.2),sum(Sale))

That separates into your top 80% of customers and bottom 20% of customers. Not sure if that's what you meant, or if you wanted the customers that made up 80% of your sales, then all other customers. If you wanted the second version, I've never figured out how to do it. I've had partial solutions that can work in specific, limited cases. I don't have a solution that I think works for this case.

Regarding 80/20 output

qliksus — Wed, 05 May 2010 07:17:30 GMT

Regarding 80/20 output

Mon, 21 Feb 2011 11:13:41 GMT

-"I have discovered a truly marvelous solution of this, which this margin is too narrow to contain"

This is just using standard functions in QV.

Regarding 80/20 output

Anonymous — Mon, 21 Feb 2011 12:00:26 GMT

Hi! It sounds great, how did you achieve it?

Regarding 80/20 output

Mon, 21 Feb 2011 12:19:28 GMT

This is a riddle... but i'll give you a hint: FirstSortedValue()

Regarding 80/20 output

Wed, 02 Mar 2011 18:50:43 GMT

Martin... It looks like your 80% of value is not correct. For 80% there should be 7/8 Customers not 12, and 70% should have 5/6.

Also, what's with the riddle? Why not help him out instead of playing games and wasting time... this is a forum to help others

Regarding 80/20 output

johnw — Wed, 02 Mar 2011 19:55:44 GMT

He's said several things that he probably thought would be helpful to someone trying to solve the problem - this is possible, it can be done with standard QlikView functions, and one of those functions is firstsortedvalue(). I assume he thought it would be better for people to think the problem through on their own than simply be handed an answer.

But I agree that the answer isn't correct (or at least isn't the solution to the problem posed by this thread). As with my own incorrect answer, I believe he's interpreting the top X% of Y customers to mean that we want X%*Y customers in the answer. But what we REALLY want are the customers that make up X% of SALES. As you note, in that case, the top 80% would include 7 or 8 customers (I'd guess 8, but I'd confirm by doing a pareto select, which is what we're trying to duplicate).