3 Replies Latest reply: Jan 18, 2018 8:35 AM by Laurent Berder RSS

    Percentage of variable corresponding to percentage of other variable

    Laurent Berder

      I have two numerical variables, and would like to calculate the percentage of one variable corresponding to at least 50% of the other variable's sum.

      For example:

      AB
      28
      120
      312
      54
      27
      111
      45

       

      Here, the sum of column B is 68, so I'm looking for the rows (in B's descending order) where cumulative sum is at least 34.

      In that case, they are rows 2, 3 & 6 (cumulative sum of 45). The sum of these row's column A is 5.

       

      Therefore, the result I'm looking for is 5 / 18 * 100 = 28%


      I'm rather new to Qlik, so do not know where to start to implement this.