Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Re: ABC Analysis w. 2 dimensions

May be try this

=Aggr(

If(RangeSum(Above(Sum(Usage)/Sum(TOTAL <CustomerID> Usage), 0, RowNo())) <= 0.50, 'A',

If(RangeSum(Above(Sum(Usage)/Sum(TOTAL <CustomerID> Usage), 0, RowNo())) <= 0.80, 'B', 'A')), CustomerID, (ProductID, (=Sum(Usage), DESC)))

Abdrakhimov
New Contributor II

Re: ABC Analysis w. 2 dimensions

That didn't work. Wrong distribution.