Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
lorenwood
Contributor III
Contributor III

Accumulate Sum for prev Year and start over at beginning of current year

Hello, I wanted to know if this is possible in Qlikview.  See below table: I am wondering if it is possible to get a rolling accumulation for the year 2013 then have the sum begin new at the beginning of 2014 the chart is broken out into Month/Year.  The desired value is in RED and BLUE

Any help would be greatly appreciated!!!

Thanks

Month / YearValueAccumulation
Jan-1355
Feb-131015
Mar-13419
Apr-13524
May-131236
Jun-13541
Jul-13849
Aug-131059
Sep-13261
Oct-13566
Nov-131076
Dec-132096
Jan-1422
Feb-1457
Mar-14815
Apr-141732
May-142052
Jun-141062
Jul-14567
Sep-14875
Oct-14681
Nov-141091
Dec-1415106

3 Replies
javier_florian
Creator III
Creator III

Hi Loren,

Try with:

-Sum({<Month={"<=$(=Num(Max(Month)))"}, Year={$(vMaxYear)}>} Value)

-JFlorian

mayck001
Contributor II
Contributor II

Try use

SUM (TOTAL( 'FIELD') )

tks

SergeyMak
Partner
Partner

Try this

RangeSum(above(Sum(Value),0,Calendar.MonthNo))

You should have a field with a number of month. In my case it's Calendar.MonthNo

Regards,
Sergey