# 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.

P.Sh.

2 Replies
Not applicable

## Re: Dynamic ABC Analysis

Take a look here: Recipe for an ABC Analysis.

- Marcus

Not applicable

## Re: Dynamic ABC Analysis

Community Browser