topic Re: ABC Analysis in QlikView

ABC Analysis

Tue, 09 Sep 2014 18:50:58 GMT

Hi there,

I have one question; I would like to have for a procurement analysis the ABC ranked sums of each category to see the relations between the sum of purchasing value, the actual inventory, the number of SKU's etc.

I found examples for a regular ABC-ranking by e.g. materialnumbers but not as sums per category.

I understand that mostprobably I have to work with a calculated dimension like this:

=if(aggr(PurchasingValue, MatNo) <= fractile(TOTAL PurchasingValue, 0.8), '-A-',

(and so on....), but in this case the result will give me as category A the first 80% of the material numbers and not the first 80% of the desired purchasing volume.

On the attached excel sheet I demonstrate the result as an example, that I would like to have...

Re: ABC Analysis

Gysbert_Wassenaar — Wed, 10 Sep 2014 08:33:44 GMT

Perhaps this document helps: ABC Analysis to set and remember classification at runtime

Re: ABC Analysis

Wed, 10 Sep 2014 14:40:55 GMT

Hi Gysbert,

first of all thank you for your remarks. Of course I know Christof's solution very well. But it exactly shows the problem I have; his ABC ranking relates to the number of vendors, not to the ranking of the purchasing volume (...that I would like to have).

So if you could think a little bit about this issue, I would be happy 😉

Guenter