topic Re: Rolling 12 months cumulative in QlikView

Rolling 12 months cumulative

Wed, 29 Jul 2015 07:12:04 GMT

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 — Wed, 29 Jul 2015 07:15:19 GMT

try this

Expression

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

In script

load

monthYear,

Sales,

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

Wed, 29 Jul 2015 07:17:58 GMT

Sorry its bymistakly press as correct answer.

i want this in backend script only.

Wed, 29 Jul 2015 07:18:33 GMT

I want this in script only

tresB — Wed, 29 Jul 2015 07:23:41 GMT

Hope that helps.

sunilkumarqv — Wed, 29 Jul 2015 07:29:31 GMT

In script

Data:

load

monthYear,

Sales,

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

Kushal_Chawda — Wed, 29 Jul 2015 07:29:53 GMT

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 — Wed, 29 Jul 2015 07:55:06 GMT

‌kajal pol:

Did you get the solutio?