Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
dwertz
Contributor II
Contributor II

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.

 

Screenshot (1).pngScreenshot (2).png

1 Solution

Accepted Solutions
Andrew_Incite
Partner - Contributor II
Partner - Contributor II

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()))

View solution in original post

4 Replies
Andrew_Incite
Partner - Contributor II
Partner - Contributor II

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()))

dwertz
Contributor II
Contributor II
Author

This worked perfectly. Thanks.
dwforest
Specialist II
Specialist II

So you have an account created record based on a date? Hard to guess without the raw data.
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.
paul_hooper
Contributor
Contributor

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!