Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try this
Expression
=aggr( rangesum(above( sum(Value), 0, rowno() )), MONTHYEAR)
In script
load
monthYear,
Sales,
Rangesum(Sales,Peek('CumSales')) as CumSales;
Sorry its bymistakly press as correct answer.
i want this in backend script only.
I want this in script only
Read this blog post: QlikView App: Accumulate values in the Data Model
Hope that helps.
In script
Data:
load
monthYear,
Sales,
Rangesum(Sales,Peek('CumSales')) as CumSales;
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
kajal pol:
Did you get the solutio?