Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ptl14624
Contributor III
Contributor III

Sum Month with Month-1

Hi!

I want to sum the sum of the current month, to the sum of the last month with values.

For example, in February I want to have all the Páginas Produzidas of February and January (image below).

Capture.JPG

Any Ideas?

Thanks

4 Replies
sunny_talwar

What expression are you using in your chart? Assuming it is Sum(Measure), change it to this

RangeSum(Before(Sum(Measure), 0, ColumnNo()))
OmarBenSalem

How to use aggr sunny in such a case; because, if the sorting order is altered, the results would be wrong.

sunny_talwar

Depending on the dimensions (assuming there is only one dimension in this chart which is MonthYear)... you can do this

Aggr(RangeSum(Above(Sum(Measure), 0, RowNo())), (MonthYear, (NUMERIC)))
OmarBenSalem

I we have one line and 2 columns

it would be ?

Aggr(

Rangesum(above( 

sum(Measure) 

,0,rowno()))

,Col2,Col1,Line1)

??

I tried as follow, it returns 0