Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Sarmie_Akintona
Contributor II
Contributor II

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?

Thanks in advance!

 

1 Solution

Accepted Solutions
Sarmie_Akintona
Contributor II
Contributor II
Author

Thank you very much, Almen.

View solution in original post

2 Replies
Almen
Creator II
Creator II

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.

Sarmie_Akintona
Contributor II
Contributor II
Author

Thank you very much, Almen.