Summarizing values in bar chart

[keithblythe]

I am new to Qlik Sense and struggling with the following concept:

I am producing a bar chart which has data similar to the following:

Month-Year	Create Count	Complete Count
1/1/2017	5	3
2/1/2017	8	6
3/1/2017	4	1
4/1/2017	8	9

I want to create a 3rd measure which sums each count.  For example the calculated 3rd measure in 2/1/2017 will be:

Sum(CreateCount) - Sum(CompleteCount)

The value calculated in 1/1/2017 will be: 5-3

The value calculated in 2/1/2017 will be:  (5+8) - (3+6)

The value calculated in 3/1/2017 will be:  (5+8+4) - (3+6+1)

The value calculated in 4/1/2017 will be: (5+8+4+8) - (3+6+1+9)

How can I accomplish this in Qlik Sense?

Thanks

[sunny_talwar · Accepted solution]

Maybe this

RangeSum(
RangeSum(Above(Sum(CreateCount), 0, RowNo())),
-RangeSum(Above(Sum(CompleteCount), 0, RowNo()))
)

[keithblythe]

Your suggestion worked.  Thank you!

[ddpotato]

Hi Keith, 

I think you can try this:

Add another measure with the following syntax:

RangeSum(Above(Sum(CreateCount), 0, RowNo()))-RangeSum(Above(Sum(CompleteCount), 0, RowNo()))

Hope it solves your question.