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!
