2 Replies Latest reply: Aug 22, 2016 11:32 AM by bruno bertels RSS

    Dynamic ABC Analysis

    Petya Shishiteva

      Hello,

       

      I am doing a dynamic ABC analysis in Qlik Sense, but I am having a hard time calculating the total number of companies which are A, B or C. I enter only company names and amount per company and using this expression for ABC column:

       

      If(RangeSum(Above(Sum(Amount per Company), 0, RowNo())) / Sum(total Amount per Company) <= 0.8, 'A',

      If(RangeSum(Above(Sum(Amount per Company), 0, RowNo())) / Sum(total Amount per Company) <= 0.9, 'B', 'C'))

       

      I end up with the following:

       

      Company Name

      Amount per

      Company

      ABC
      i 9,903,661 A
      k 7,708,646 A
      g 7,215,748 A
      j 7,101,515 A
      e 5,472,607 A
      h 5,120,046 A
      f 4,863,828 A
      d 4,285,342 A
      l 3,693,784 B
      b 3,438,134 B
      m 3,257,506 C
      c 2,232,243 C
      n 1,911,538 C
      o 1,383,648 C
      a     82,750 C

       

      Now I would like to calculate the total number of companies which are A, B or C in a separate table. I tried in many different ways, but without any luck.

       

      I would really appreciate your help! Thanks in advance and cheers!  

      P.Sh.