Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
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
Not applicable

Re: Dynamic ABC Analysis

Take a look here: Recipe for an ABC Analysis.

- Marcus

brunobertels
Not applicable

Re: Dynamic ABC Analysis