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.
