Discussion board where members can get started with QlikView.
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:
What I want to build is a line chart with 2 lines -
Dimension - Date
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)
Go to Solution.
As per what i have understood this mite be your output.
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!!!