0 Replies Latest reply: Jul 7, 2015 5:19 AM by Reinhard Lubig RSS

    Aggregation of top 15 distributors

      Hello, I am new not QlikView and got a big Problem.


      I got a Table with each Order in one row:

      - OrderDate

      - Distributor

      - more Fields which are not concerned with my Problem.


      Now I have to do Analysis of Top 15 Distributor for each month like this:

      Count orders of month and list them 12 Month in a row like this:

                Jan                count   Feb                count    Mrc                count      Apr      ...

      Top 1  Distributor1     127      Distributor27    150       Distributor50    180

      Top 2  Distributor19   111       Distributor50     99


      Top 15 Distributor27   50        Distributor1    


      I know I have to use aggr, but i got no idea how to manage data in order to get only the top 15 in the grid above.


      Thank you for all help and solutions.


      Best regards

      r. Lubig