2 Replies Latest reply: Oct 27, 2015 8:35 AM by imren çimen RSS

    stock-order sufficient table (Reduced Stock)

    imren çimen

      Hi,

       

      I made this table in excel but couldn't show this form in qlikview?  qlikview shows total inventory. how can ı show 'inventory-order quantity' row?

         

      ItemdateweekQlikView-total inventoryinventory-order quantityQlikview-order quantitylast inventoryShipped Quantity
      xxxxxxxx08.06.20152015-2437374,00033,0004,000
      xxxxxxxx08.06.20152015-2437335,00028,0005,000
      xxxxxxxx08.06.20152015-24372810,00018,00010,000
      xxxxxxxx09.06.20152015-24371850,0000,00018,000
      xxxxxxxx15.06.20152015-253706,0000,0000,000
      xxxxxxxx15.06.20152015-2537010,0000,0000,000
      yyyyyyyy15.06.20152015-25885,0003,0005,000
      yyyyyyyy27.05.20152015-22835,0000,0003,000
      yyyyyyyy04.08.20152015-32801,0000,0000,000
        • Re: stock-order sufficient table (Reduced Stock)
          Manish Kachhia

          Can you please provide the table which you are looking for? Your question looks incomplete !

          • Re: stock-order sufficient table (Reduced Stock)
            imren çimen
            ItemdateweekQlikView-total inventoryinventory-order quantityQlikview-order quantitylast inventoryShipped Quantity
            xxxxxxxx08.06.20152015-2437374,00033,0004,000
            xxxxxxxx08.06.20152015-2437335,00028,0005,000
            xxxxxxxx08.06.20152015-24372810,00018,00010,000
            xxxxxxxx09.06.20152015-24371850,0000,00018,000
            xxxxxxxx15.06.20152015-253706,0000,0000,000
            xxxxxxxx15.06.20152015-2537010,0000,0000,000
            yyyyyyyy15.06.20152015-25885,0003,0005,000
            yyyyyyyy27.05.20152015-22835,0000,0003,000
            yyyyyyyy04.08.20152015-32801,0000,0000,000

             

             

            xxxxxxxx item,

            inventory decrease related with the orders (orders 4-5-10-50) total stock is 37 qt. Assign this stock for orders. xxxxx's first order is 4 qt. 37-4=33 qt is last inventory, fo second row my stock must be 33  (37-33-28-18) but ı can't. qlikview shows total inventory 37 qt in every xxxxxxx row.