topic Re: Cumulative Sum for Last 12 Months in QlikView

Solved

microwin88x — Wed, 09 Sep 2015 19:50:52 GMT

Solved

maxgro — Wed, 09 Sep 2015 20:17:51 GMT

LOAD

PERIOD,

CURRENT_DATE,

AMOUNT,

ACUM.,

rangesum(

AMOUNT,

Peek(AMOUNT,-1),Peek(AMOUNT,-2),Peek(AMOUNT,-3),

Peek(AMOUNT,-4),Peek(AMOUNT,-5),Peek(AMOUNT,-6),

Peek(AMOUNT,-7),Peek(AMOUNT,-8),Peek(AMOUNT,-9),

Peek(AMOUNT,-10),Peek(AMOUNT,-11)

)

FROM

(html, codepage is 1252, embedded labels, table is @1);

microwin88x — Wed, 09 Sep 2015 20:39:42 GMT

Thanks Massimo! This seems to work!

Anyway, would it be possible to use a single function so that I don't have to use many Peeks?

Or this is the best way we could use? Thanks!!!

sinanozdemir — Wed, 09 Sep 2015 20:45:07 GMT

You can achieve this in a straight table with only one function. Although, it seems that you wanted to accomplish it in the back-end:

maxgro — Wed, 09 Sep 2015 20:45:45 GMT

don't know if it's the best, at the moment for me it's the only one (well, mee too, I don't like it very much)