Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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

Re: Calculate stock level

Hello,

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

2 Replies
Not applicable

Re: Calculate stock level

Hello,

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

Not applicable

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

Community Browser