topic Re: Problems with an ABC-analysis in QlikView

Problems with an ABC-analysis

cscherer — Fri, 03 Aug 2012 09:04:50 GMT

Hello,

I hope you can help me out. Sorry, if I´m in the wrong area, but it`s my first posting.

I´m trying to make an ABC-analysis. For that I accumulate the amount of articles in column 5. In the next step I want to say with an if-formula, if this article is an A-, B- or C-Article. If the amount is less than 80% it is an A-article, between 80 and 95% it is an B-article and over 95% it is an C-article.

With this formula it doesn`t work...

if( Column(5) < 0.80 , 'A', if( Column(5) > 0.95 , 'C', 'B'))

Have you got an idea

Thanks in advance,

best regards,

Clemens

Re: Problems with an ABC-analysis

Fri, 03 Aug 2012 10:31:35 GMT

IMO better way will be :

- paste $(Anteil kum.)= rangesum(above(Count(PACKMENGE) / count(TOTAL(PACKMENGE)),0,rowno())) as amount cum. and make no acumulation

- paste =if( Column(4) < 0.80 , 'A', if( Column(4) > 0.95 , 'C', 'B'))

Re: Problems with an ABC-analysis

cscherer — Fri, 03 Aug 2012 10:57:56 GMT

Hello,

thanks for answer, it works.

But now there is a new problem: I sorted the table descending by 'positions'. Now the sorting doesn`t work any more. Any idea?

Thanks!

Re: Problems with an ABC-analysis

Fri, 03 Aug 2012 11:28:04 GMT

because you still have accumulation in amount cum. right?

select No Accumulation

BTW - if you use rangesum(above(..... you can only sort dimension (interactive sort does not work)

which is strange:/

anybody knows why?

Re: Problems with an ABC-analysis

cscherer — Fri, 03 Aug 2012 12:13:28 GMT

no, I did as you said and selected 'No Accumulation'.

I do also wonder why the sort does work with dimension but not with the formula...

Re: Problems with an ABC-analysis

Fri, 03 Aug 2012 12:44:12 GMT

Hi Clemens,

Probably this blog about abc analysis I wrote some time ago is interesting for you: http://www.quickqlearqool.nl/?p=1086

Regards William

Re: Problems with an ABC-analysis

cscherer — Fri, 03 Aug 2012 13:03:00 GMT

Hi William,

this is nice, thank you very much!

Regards,

Clemens