Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

imrencimen
New Contributor III

stock-order sufficient table (Reduced Stock)

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
2 Replies

Re: stock-order sufficient table (Reduced Stock)

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

imrencimen
New Contributor III

Re: stock-order sufficient table (Reduced Stock)

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.

Community Browser