3 Replies Latest reply: Apr 8, 2014 9:57 PM by Sergey Makushinsky RSS

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

    Loren Wood

      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