Accumlation of n month

[#1]

Hello,

I'm new to QlikView.

I've the month accumulated for each account. I want to show, in a text object, the amount accumulated for the previous n-months, according the selected month by the user.

I use this expresion

=Num(RangeSum(Above(Sum({< [Cuenta Contable] = {'572*'} >} [Saldo Cta Contable]), 0, Mes)), '#,##0.00')

but only accumulate the selected month.

TIA

Antonio

[MayilVahanan · Accepted solution]

Hi

Try like this

Calculating rolling n-period totals, averages or other aggregations