topic ABC Analysis - Stock Value in QlikView

ABC Analysis - Stock Value

Thu, 18 Mar 2010 07:24:18 GMT

Hi All,

I need to give stock items a class character depending on which category they sit in.

Each class refers to the % of Total purchase value for a given date period.

Class % of Total

A 70

B 20

C 10

D 0

I need to be able to use the class character as a dimension in pivot tables, or at least use it as a selectable field in a list box - hence it may not be best to use as an expression.

What are your thoughts?

See below, each of these stock items would sit in the top 70% of stock purchase value, so they need to be allocated an 'A'.

Help would be greatly appreciated.

ABC Analysis - Stock Value

Thu, 18 Mar 2010 10:15:11 GMT

Hi Matt,

I found this example in my archive.

Hope it´s helpful.

Good luck!

Rainer

ABC Analysis - Stock Value

Thu, 18 Mar 2010 11:32:50 GMT

that looks awesome, thanks so much!

ABC Analysis - Stock Value

Sat, 27 Mar 2010 08:29:16 GMT

Hi Rainer/ Guys,

How would you achieve the same result in the script?

I need to evaluate a Stock Item as an ABC class as a field in my data model. It will also need to be date specific (i.e. ABC evaluation will change based on some date parameters (i.e. year/month)).

ABC Analysis - Stock Value

temmer — Mon, 22 Nov 2010 10:50:53 GMT

I am also using this kind of an ABC-Analysis. Additional I need a graph showing the amount of companies sitting in A, B or C. - a bar chart.

is this possible?

(I`ve had no success ...)

thank you