topic Pareto Select in Action in QlikView

Pareto Select in Action

Wed, 08 Dec 2010 06:21:30 GMT

Hi,

What is the Purpose of Pareto Select? How it can be used?

Pareto Select in Action

Wed, 08 Dec 2010 06:33:11 GMT

This type of selection is used to select the top contributors to a measure, typically in line of a general 80/20 rule. For example, to find the top customers that contribute to 80% of the turnover, then Customer should be used as field, sum(Turnover) should be used as expression and 80 should be used as percentage.

Pareto Select in Action

Wed, 26 Jan 2011 12:48:38 GMT

Hello mOngkz,

How would you make it so that only the LOWER 20% appear?

Cheers,

Re: Pareto Select in Action

marcelo_7 — Tue, 19 Nov 2013 08:19:32 GMT

One possibility would be to select excluded afterwards.

Re: Pareto Select in Action

Anonymous — Thu, 30 Mar 2017 10:00:58 GMT

One way of doing this is by selecting the 'complement' box within the Pareto Action in the properties of your button.

Just be careful with this one, based on your data structure, the complement might not exclude all values.

I had a scenario where my dimension was in weeks, and the 80% mark lied within a certain week.

Example: Pareto select of 80% yielded week 1-4

Pareto select of 20% on the same data yielded week 4-xx

Correctly calculating the data would yield that 20% was from week 5 and onward.

Re: Pareto Select in Action

Anonymous — Thu, 30 Mar 2017 10:06:09 GMT

Pareto select within a button action will select all records (based on your specified field) which add up to a predefined percentage of a calculated expression.

Example (as given above),

If you would like to determine the nr of customers who contribute to 80% of sales in your company, the you would use the Pareto Select with a percentage of 80%.

The syntax used in the action properties is a bit weird, it does not take in '=' for expressions and fields.

Re: Pareto Select in Action

Anonymous — Thu, 11 May 2017 09:44:31 GMT

You could set it up as below:

Field: Customer

Expression: =Max(ALL Aggr(Sum(Turnover),Customer)) - Sum(Turnover)

Percentage: 20