4 Replies Latest reply: Mar 21, 2011 4:04 PM by ezequiel.villemur RSS

    Problem with Accumulated Function


      Hi, I`m new user of QlikView, and i have a problem with the acumulated function.

      Have fields, Month, Year and combinated Year/Month.

      I need accumulate in a pivot table, the sum of cost (nValor) of the year 2010 and year 2011 separated

      How I determine inferior limits?? example 2010/01 and 2011/01
      If the user maks feb/2011, in first column need the accum of 2011(jan+feb 2011) and other column the accum of 2010 (jan+feb2011)

      I tried with Rangesum and Accumulated Function.
      Sorry my english I am a little rusty