New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$300 before February 6: REGISTER NOW!
cancel
Showing results for
Did you mean:
Contributor II

How does Cumulative Sum work with RangeSum and Peek in script editor?

Hi,

this a bit different question: I found a script showing how to calculate a cumulative sum in load editor using RangeSum() and Peek(). Although I know both these functions I can't understand how they work together and return a proper Cumulative Sum. Can someone explain me how Peek() works as an argument in RangeSum()?

The concept is:

test:

date,

RangeSum(value,Peek(CumulativeSum)) as CumulativeSum

;

date,value

2018-01-01,10

2018-01-02,5

2018-01-03,2

2018-01-04,7

];

The output is:

dateCumulativeSum
2018-01-0110
2018-01-0215
2018-01-0317
2018-01-0424
1 Solution

Accepted Solutions
Partner - Specialist III

HI Piotr,

As for your data the following will apply:

datevalueRangeSum(value;peek(value)) as CumulativeSumpeek(CumulativeSum)
2018-01-011010-
2018-01-02510+510
2018-01-03215+215
2018-01-04717+717

It's a visual interpretation of what it will do.

Just don't forget to order your data by date field, like:

```test:
date,value
2018-01-01,10
2018-01-02,5
2018-01-03,2
2018-01-04,7
];

finalData:
*,
RangeSum(value,Peek(CumulativeSum)) as CumulativeSum
Resident test
order by date;

drop table test;

```

or esle the peek function will get quite weird behavior on the data.

Hope it helps

3 Replies
Partner - Specialist III

HI Piotr,

As for your data the following will apply:

datevalueRangeSum(value;peek(value)) as CumulativeSumpeek(CumulativeSum)
2018-01-011010-
2018-01-02510+510
2018-01-03215+215
2018-01-04717+717

It's a visual interpretation of what it will do.

Just don't forget to order your data by date field, like:

```test:
date,value
2018-01-01,10
2018-01-02,5
2018-01-03,2
2018-01-04,7
];

finalData:
*,
RangeSum(value,Peek(CumulativeSum)) as CumulativeSum
Resident test
order by date;

drop table test;

```

or esle the peek function will get quite weird behavior on the data.

Hope it helps

Contributor II
Author

Hi Felip,

thanks for clarifying, now I finally get the concept

Partner - Specialist III