Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic ABC Analysis

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.

2 Replies
marcus_sommer

Take a look here: Recipe for an ABC Analysis.

- Marcus

brunobertels
Master
Master