Rolling 12 months cumulative

[#1]

hi,

I want cumulative of previous 12 months.

If I select april-2015 then it should cumulate values from  may-2014 to Selected month-year i.e april-2015.

plz help.

its urgent

Thanks in advance.

[sunilkumarqv]

try this

Expression

=aggr( rangesum(above( sum(Value), 0, rowno() )), MONTHYEAR)

In script

load

monthYear,

Sales,

Rangesum(Sales,Peek('CumSales')) as CumSales;

[#3]

Sorry its bymistakly press as correct answer.

i want this in backend script only.

[#4]

I want this in script only

[tresB]

Read this blog post: QlikView App: Accumulate values in the Data Model

Hope that helps.

[sunilkumarqv]

In script

Data:

load

monthYear,

Sales,

Rangesum(Sales,Peek('CumSales')) as CumSales;

[Kushal_Chawda]

Use the below expression

=sum({<MonthYear={">=$(addmonths(max(MonthYear),-11))<=$(addmonths(max(MonthYear),0))"}, Year=,Month=>}Amount)

where MonthYear should be calculated using monthname(Date)

Please see the attached

[qlikviewwizard]

‌kajal pol:

Did you get the solutio?