Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Date | Qty remaining |
---|---|
02/11 | 500 |
05/11 | 450 |
10/11 | 400 |
Sales:
Date | Qty sold |
---|---|
02/11 | 15 |
03/11 | 20 |
04/11 | 5 |
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!!!
Hello,
As per what i have understood this mite be your output.
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!!!