
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Cumulative Count in Bar Chart
I'm currently showing the count of new users in a given account creation YearMonth dimension. I need to show a cumulative count of users at the end of each of these months. Does anyone know a formula that will allow me to do this? I'm including a pair of screenshots as well to try and make my question clearer. The top is where I'm currently at, and the bottom is the sheet I'm trying to reproduce using raw data (rather than a processed data excel file that I used to create the bottom sheet).
Right now my dimension is YearMonth and I'm doing a simple count(Username) and count(Admin) as my measures.
Any advice would be appreciated as I'm still learning to use Qlik.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should be able to do a range sum, which looks at the row and the row above it continuously for every dimension value.
RangeSum (above(count(Username),0,RowNo()))
RangeSum (above(count(Admin),0,RowNo()))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You should be able to do a range sum, which looks at the row and the row above it continuously for every dimension value.
RangeSum (above(count(Username),0,RowNo()))
RangeSum (above(count(Admin),0,RowNo()))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you hook up a calendar it will allow to easily aggregate by any dimension in the calendar, e.g. Month, Week, Quarter.
You could also MonthName(Date) your data and use that.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you! I've been searching for a simple way of doing this for what feels like a significant fraction of eternity, and this solution works perfectly!
