4 Replies Latest reply: Jan 17, 2014 6:13 AM by Gysbert Wassenaar RSS

    How to use dynamic date to analyse sales vs latest stock

      Hello,

       

      I'm new to Qlikview and I try to create my own analyses for my Retail business (sales, stock, orders, delivery)

      I would like to create a view per product where I can see the following:

       

      SKUSales QtyQty On HandQty OrderedQty Delivered
      SKU 11045014

      SKU 2

      1566021
      etc.

       

      I would like to use a filter on the Sales date, so I can get the sum or average Qty Sold on the period I select. However, when I do this, my Qty On Hand, ordered and delivered are all 0 (there is no date in stock table as it's always the current stock).

       

      How should I import and link my facts table (sales, stock, order, delivery) and dimensions tables (Store info, Item info) ?

       

      Thank you