2 Replies Latest reply: Dec 3, 2012 6:18 AM by yallow83 RSS

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