Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
Showing results for 
Search instead for 
Did you mean: 
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
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
Contributor II
Contributor II

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

Contributor II
Contributor II

What I need is a table like below

ItemnrWarehousenrIn Stock
MVP & Luminary
MVP & Luminary

See attached qvw.

talk is cheap, supply exceeds demand