Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Contributor II
Contributor II

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

Highlighted
Contributor II
Contributor II

What I need is a table like below

ItemnrWarehousenrIn Stock
40501513
40501536
1000016123610
100001641050
10000168400
100001610600
Highlighted
MVP & Luminary
MVP & Luminary

See attached qvw.


talk is cheap, supply exceeds demand