topic Re: Calculate stock level in QlikView

Calculate stock level

Sun, 02 Dec 2012 23:47:24 GMT

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:

Sales:

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!!!

Mon, 03 Dec 2012 09:43:40 GMT

Hello,

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

Mon, 03 Dec 2012 11:18:33 GMT

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!!!