This content has been marked as final. Show 3 replies
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.
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
In that case, they are rows 2, 3 & 6 (cumulative sum of
45). The sum of these row's column A is
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.