TOP 20% analysis

Tue, 28 Jul 2015 18:28:37 GMT

Hi everybody,

I have a raw tabel w/t following fields:

- customer

- revenues product P1

- revenues product P2

- revenues product P3

- total revenues

I need to:

1 - find top 20% customers (i.e. customers whose revenues are the 20% of Total revenues)

2 - for each product find the average product revenues among top20% customers (let's say AVG_P1, AVG_P2, AVG_P3)

3 - for each customers calculate the difference (revenue product P1 - AVG_P1)

Is there any QLIK function that could be used for that purpose?

Thanks in advance

Emanuele

Re: TOP 20% analysis

Gysbert_Wassenaar — Wed, 29 Jul 2015 13:39:25 GMT

You can probably use Dimension Limits to show the top 20% revenue customers.

I'm not sure what you're trying to calculate with questions 2 and 3. Can you post a qlikview document that explains those?