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

Count if out of stock between current date and leadtime

Hi all,

I am trying to show if a product is going to be out of stock between the current date and current date + the leadtime of the product.

 

For example:

I have a current stock (Stock) of 10.000

The leadtime of the product to be delivered at our warehouse is 30 days

The (linear) demand from our  customers in those 30 days will be 20.000.

I have a pending shipment from our supplier of 30.000 which will be deliverd in approximately 24 days.

 

This will mean that we will be out of stock around day 15 till day 24.

 

How can I show this in a table saying:

Product | Current Stock | Date out of stock | Date back in stock

 

Any help will be appreciated! 

Labels (2)
0 Replies