4 Replies Latest reply: Dec 31, 2014 9:28 AM by Gysbert Wassenaar RSS

    Show Actual Inventory

    Marco van Zand

      Dear Qlikviewers,

       

      I need a definition to show me the actual inventory and how low long we have it.

      The columns are:

      - DateX

      - Itemnr

      - Serialnr

      - Warehousenr

      - InventoryOld

      - Mutation

      - InventoryNew

      - Days  -------------------> Calculate how many between the previous mutation (by Itemnr and Warehousenr)

      - DaysInventory   -----> Days * InventoryOld

       

      I need per Itemnr per Warehousenr the actual inventory