Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tomhovens
Contributor II
Contributor II

Show Actual Inventory

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

4 Replies
Gysbert_Wassenaar

See attached qvw. As far as I can tell you did not give enough information. You didn't mention that Serialnr also needs to be considered. And there's probably something else since your table contains 0 for Itemnr 405015 in Warehouse 1 with Serialnr 1 on 4/17/2014. And that date is 27 days after 3/21/2014. So what's the reason there's a 0 instead of 27?


talk is cheap, supply exceeds demand
tomhovens
Contributor II
Contributor II
Author

When there are multiple mutation on 1 singe day the serialnr counts them

tomhovens
Contributor II
Contributor II
Author

What I need is a table like below

ItemnrWarehousenrIn Stock
40501513
40501536
1000016123610
100001641050
10000168400
100001610600
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand