Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
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