If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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).
What expression are you using in your chart? Assuming it is Sum(Measure), change it to this
RangeSum(Before(Sum(Measure), 0, ColumnNo()))
How to use aggr sunny in such a case; because, if the sorting order is altered, the results would be wrong.
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)))
I we have one line and 2 columns
it would be ?
I tried as follow, it returns 0