0 Replies Latest reply: Sep 19, 2016 11:24 AM by Mateusz Pawlak RSS

    Aggr Sum - problem

    Mateusz Pawlak

      Hi all,

       

      i'm new in a Qlik Sense Community and I have one small problem with Qlik and function AGGR.

       

      I try to show it on short example:


      1. Tabel with parts order:


      Part numberOrder
      A50
      B100
      C25
      D50
      E75

       


      2. Tabel with parts in groups:


      GroupPart number
      IA
      IC
      IIB
      IID
      IIIE



      The case is, I'd like to say that part "A" is 66% of whole orders in group I and part "C" is 33% (for "A" 50/75 and for "C" 25/75)


      The new table could look like below:

       

      GroupPart numbershare in %
      IA33%
      IC66%
      IIB66%
      IID33%
      IIIE100%


      I'v try to solve it with function AGGR and SUM, but it didn't work. Maybe is another way or one of you had once problem like that?


      Aggr(Sum(Order), Part number)/Aggr(Aggr(Sum(Order), Group)


      Thank you guys a lot and I'm sorry 4 my English

       


      Mateusz