
Contributor III
2018-03-25
01:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
rangesum for year and month measure
Hi all,
I have a question about using rangesum in qlikview:
I have a year, month and amount as fields; I want to show sum of amount and also cumulative sum of amount(from beginning till that month) in another column:
year | Month | Sum(amount) | Cumulative sum(amount) |
2016 | 10 | 100 | 100 |
2016 | 11 | 200 | 300 |
2016 | 12 | 300 | 600 |
2017 | 1 | 400 | 1000 |
2017 | 2 | 500 | 1500 |
2017 | 3 | 600 | 2100 |
But when I use following formula for calculating cumulative sum It doesn’t work well, it just works for months of any single year:
Rangesum( Above(Count( amount), 0, RowNo()))
Any help would be appreciated
2,250 Views
1 Solution
Accepted Solutions

Partner - Champion III
2018-03-25
01:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try: Rangesum( Above(total Count( amount), 0, RowNo(total)))
talk is cheap, supply exceeds demand
2 Replies

Partner - Champion III
2018-03-25
01:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try: Rangesum( Above(total Count( amount), 0, RowNo(total)))
talk is cheap, supply exceeds demand

Contributor III
2018-03-25
03:37 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It worked.Thanks in advance!
2,079 Views
