Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Out of stock and risk of out of stock signalling

Hi all,


I have 3 different tables in excel:

1. A table with article information. Fields: Artnr (= article number), Stock_Today (= current stocklevel) and Leadtime (= the leadtime of the specific article from orderdate to date in warehouse)

2. A table with a salesforecast per day per article, where the demand per day is different each day. Fields: Artnr, Demand_Date, Demand_Quantity

3. A table with shipment information. Fields: Artnr, Delivery_Date, Shipment_Quantity


What I want to see (in a table) is:

- which articles will go out of stock between today and their leadtime. 

- the date of going out of stock

- the date of the next shipment delivery

- the out of stock risks (= the out of stocks when Demand_Quantity is x% higher than forecasted. x Should be a variable which can be adjusted manually


Thanks in advance!

Labels (5)
1 Reply

Please share sample dataset.