An accumulated measure in line chart

[aheavy95]

Hi all 

I need to create a graph that shows the number of users that exist in the DB who have filled the birthdate field.

The red line shows the number of new birthdate fields which were added in the system each month, using a simple: count(UserBirthDate) calculation.

However, in the yellow line, I am trying to show the amount birthdates in the DB in an accumulated way. for example, 

if the chart starts in 01-2022 and the number of birthdate values added in the first 3 months are:

01- 300

02- 200

03- 100

I will get the following: 

01- 300

02- 500

03-600

I have already tried the following formula but the values I get are way larger:

RangeSum(Above( total count(
UserBirthDate), 0, RowNo(total)))

Does anyone have an idea how can I do this the right way?

Thanks

[Lisa_P]

IF you duplicate the measure for the count(UserBirthDate), then in the Properties panel, expand that measure, and click on Modifier, Accumulation, this line should show the accumulation for you.

[aheavy95]

Hi

You are probably talking about Qlikview

I am using Qlik Sense

[Lisa_P]

This feature has been in Qlik Sense for over a year , I can't find exact release this was added.