Regarding 80/20 output

[qliksus]

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.

[#2 · Accepted solution]

hi

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

jj

[qliksus]

Hi,

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

[#4]

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>

[#5]

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

[qliksus]

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???????

[#7]

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

[johnw]

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.

[qliksus]

hi

[#10]

-"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.