I am trying to create a Line Graph which shows multiple cumulative lines for different measures.
In the attached example, I have two contracts each with an allocated amount of hours, I would like to display the cumulative hours for each contract on one single graph.
From some initial research into this, I have created the graph which has the Dimensions Group as 'Date.autoCalendar.Date', the Dimensions Line is 'Contract' and the Measure Height is 'Aggr(RangeSum(Above(Sum(Hours), 0, RowNo())), [Date.autoCalendar.Date], Contract)'.
This doesn't give me what I want, and I don't understand why, as the formula has appeared to work for other examples!
Any help on this would be greatly appreciated.
I am using Qlik Sense Desktop June 2019 (qliksensedesktop:13.32.2).