topic Stock level forecast in QlikView

Stock level forecast

ulyxess1983 — Mon, 18 Apr 2011 14:04:26 GMT

Hi everyone,

Could you give me a hint how to make a forecast of stock level?

I have ItemId, StockLevel, AvgOutcome

I need to make a +14 days forecast - on daily basis

Example:

item stock avg_outcome day 1 day 2 day 3

101 200 -70 130 60 -10

Thanks in advance!

My file in attachment[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/5102.StockAnalysis.zip:550:0]

Stock level forecast

nathanfurby — Mon, 18 Apr 2011 14:29:43 GMT

Which one of your columns in your attached example represents the "avg_outcome" column that you mentioned above?

Stock level forecast

ulyxess1983 — Mon, 18 Apr 2011 14:33:46 GMT

Hi Nathan,

Thanks for quick reply.

(Qty1 / 14) is AvgOutcome for 14 days before today.

KR,

Michail

Stock level forecast

nathanfurby — Mon, 18 Apr 2011 14:43:13 GMT

and you just want 14 columns to the right showing the declining stock levels over 14 days?

Stock level forecast

ulyxess1983 — Mon, 18 Apr 2011 18:19:53 GMT

Yep, just cumulative variance between stock and avg outcome by days to see when the product will be out of stock.

Stock level forecast

nathanfurby — Tue, 19 Apr 2011 08:56:47 GMT

If you always want 14 columns to the right then just hard code them:

Stock + avg_outcome

Stock + (avg_outcome * 2)

Stock + (avg_outcome * 3)

etc...

I'm sure there are prettier ways, but would only take a second to implement.

Stock level forecast

ulyxess1983 — Tue, 19 Apr 2011 10:50:06 GMT

Thanks, Nathan

Wonderful idea. I use (Date-Today()) as N counter for (Stock + Avg_Outcome * N)

Cheers,

Michael

Stock level forecast

nathanfurby — Tue, 19 Apr 2011 10:56:37 GMT

OK - don't think I understood your requirements completely, but glad you found a solution.