Pareto class as dimension

ali_hijazi — Thu, 17 Nov 2016 10:44:07 GMT

Hello

I'm trying to have the pareto class as dimension using the class function

the calculated dimension i'm using is like this:

=class(aggr(RangeSum(Above(($(vNetSales)), 1, RowNo())) / ($(vTotal_NetSales)),ItemDesc1),0.8)

the expression RangeSum(Above(($(vNetSales)), 1, RowNo())) / ($(vTotal_NetSales))

is for the exclusive percentage as per the following article (Recipe for a Pareto Analysis)

Followin the above article I got the following:

using the class function I got the following:

I got 5 items whose exclusive percentage between 0.8 and 1.6 but actually on the first table the items are 6 under class A

I really got lost

please advise

Re: Pareto class as dimension

sunny_talwar — Thu, 17 Nov 2016 10:50:03 GMT

I think the issue you are running into is the sorting which is done by load order (because you are using Aggr() function in your dimension). See if this thread offers any solution: ABC Analysis in Qlikview

topic Pareto class as dimension in QlikView

Pareto class as dimension

Re: Pareto class as dimension