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.
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.