Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
microwin88x
Creator III
Creator III

Solved

Solved

1 Solution

Accepted Solutions
maxgro
MVP
MVP

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);

View solution in original post

4 Replies
maxgro
MVP
MVP

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);

microwin88x
Creator III
Creator III
Author

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
Specialist III
Specialist III

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:

Capture.PNG

maxgro
MVP
MVP

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)