Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
When there are multiple mutation on 1 singe day the serialnr counts them
What I need is a table like below
Itemnr | Warehousenr | In Stock |
---|---|---|
405015 | 1 | 3 |
405015 | 3 | 6 |
1000016 | 1 | 23610 |
1000016 | 4 | 1050 |
1000016 | 8 | 400 |
1000016 | 10 | 600 |
See attached qvw.