Stock level forecast

[ulyxess1983]

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]

[nathanfurby]

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

[ulyxess1983]

Hi Nathan,

Thanks for quick reply.

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

KR,

Michail

[nathanfurby]

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

[ulyxess1983]

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

[nathanfurby · Accepted solution]

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.

[ulyxess1983]

Thanks, Nathan

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

Cheers,

Michael

[nathanfurby]

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