7 Replies Latest reply: Dec 5, 2014 4:42 PM by Brian Hockenmaier RSS

    Utilization in Qlikview

    Marco van Zand

      Hey Qlikviewer,

       

      Can anybody help me to calcule the utilization of the inventory, see the tabel

       

      OrdernrItemnrQuantityStartDateEndDateUtilization
      10011024/11/201427/11/201440
      1002524/11/201427/11/201420
      2001521/11/201425/11/201425
      20021521/11/201425/11/201475
      3001125/11/201401/12/20147
      3002225/11/201401/12/201414

       

      I made a selection of the order between 22/11/2014 and 28/11/2014 but the utilization must calculate with these dates.

      Ordernr 1 is good

      Ordernr 2 the StartDate has to be 22/11/2014

      Ordernr 3 the EndDate has to be 28/11/2014

       

      Who can help me?