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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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)