Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Solved
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
[https://community.qlik.com/thread/179879]
(html, codepage is 1252, embedded labels, table is @1);
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
[https://community.qlik.com/thread/179879]
(html, codepage is 1252, embedded labels, table is @1);
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!!!
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:
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)