Cumulative Sum with RangeSum but Sorted Disorderly
Hello Qlik People,
I am trying to plot two cumulative sums over a dimension(date). I did use the RangeSum(Above(Sum(Measure1), 0, RowNo())) and RangeSum(Above(Sum(Measure2), 0, RowNo())) to compute the measures. The computations are absolutely correct but the sorting of the dimension is disorderly, with no obvious pattern. I used the Sort by Expression with Datefield in the expression but the sorting remained disorderly. Could someone help suggest a way out for me?
If the measure field and date field are in the same table, you can make a resident table and use order by date desc or asc. Add RowNo() as RowNo in that table and use that field in your expression when sorting by expression.