2 Replies Latest reply: Dec 3, 2012 6:18 AM by yallow83

# Calculate stock level

Hi,

Sorry that I only post questions so far. I will assist people too when I get more familiar with the tool.

We are running a clearance business - so we need to sell everything by a certain date.

I have 2 tables:

Inventory:

DateQty remaining
02/11500
05/11450
10/11400

Sales:

DateQty sold
02/1115
03/1120
04/115

What I want to build is a line chart with 2 lines -

Dimension - Date

Expressions:

1) Qty sold

2) (Qty remaining) divided by (number of days till deadline remaining)

i.e. how many units we need to sell daily on average to meet deadline.

As I am totally new to qlikview (2-3 weeks of playing with it so far) I need some guidance how to do this line chart.

So a couple of questions -

1) In the inventory table some dates are missing, how can I fix this?

2) How do I calculate the second expression? I need an input box for it, right? (deadline date), and then a formula like this? -

(Qty remaining) / (deadline date - inventory date)

Many thanks!!!

• ###### Re: Calculate stock level

Hello,

As per what i have understood this mite be your output.

• ###### Re: Calculate stock level

Thanks Priya.

It's kind of what I need - but I wanted to have both those expressions on one chart.

I tried to add the expression from the second chart you provided to the first one - but it errors.

I want to be able to compare actual units sold pre day with how many we need to sell every day (forecast).

The forecast is calculated as Total inventory / number of days remaining till deadline.

Many thanks for looking!!!