Onhand run out of base on ship date

[tonik_23]

Hello,

I need to create a report to show how long will it take to run out of current material availability based on the sale's ship date. I attach simple excel file to explain what I need.

[chrismarlow]

Hi,

I think you should be able to do this using Structured Parameter in AGGR function - see other answers like this one Solved: Cumulative Values in Line Chart - Rangesum - Abo... - Qlik Community - 1647730

I had to add a dimension in script combining Year and Month to make this work;

Then this in the chart;

Possibly someone smarter/more up to date might know a way without having to create YearMonth.

Cheers,

Chris.