1 Reply Latest reply: Jul 29, 2015 9:39 AM by Gysbert Wassenaar RSS

    TOP 20% analysis

    Emanuele Occhipinti

      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