topic Re: Show Actual Inventory in QlikView

Show Actual Inventory

tomhovens — Mon, 29 Dec 2014 14:16:38 GMT

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

Re: Show Actual Inventory

Gysbert_Wassenaar — Mon, 29 Dec 2014 15:01:53 GMT

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?

Re: Show Actual Inventory

tomhovens — Mon, 29 Dec 2014 15:06:56 GMT

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

Re: Show Actual Inventory

tomhovens — Tue, 30 Dec 2014 08:04:59 GMT

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

Re: Show Actual Inventory

Gysbert_Wassenaar — Wed, 31 Dec 2014 14:28:59 GMT

See attached qvw.