Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
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
Partner
Partner

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
Partner
Partner

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