Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

1 Solution

Accepted Solutions
Not applicable
Author

Hello,

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

View solution in original post

2 Replies
Not applicable
Author

Hello,

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

Not applicable
Author

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