Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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

tomhovens
Contributor II
Contributor II

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