QlikView RangeSum function computation time

1k views Asked by At

I would like to us Qlik ''RangeSum'' function.But for huge data (150000 rows) Rangsum function calculating for long time (more than five minutes) then I must have to stop Qlik and start again.

 RangeSum(Above(Sum(Sales), 0, RowNo()))

What is the problem? Thank you:-)

Data Model

2

There are 2 answers

0
alf.cz On

I think, that problem is can be in your (probably) small virtual memory, or in bad data model. If you are using for computing some server in company, can be problem on this server...

0
zhihong On

Encounter the same issue when using rangesum(), and the final calculated rows can be 1000 in the table. Searched a little bit, and the suggestion is not use rangesum() for this kind of calculation, but load it in script first. Check more detail from QV community here. https://community.qlik.com/message/1185988#1185988

Zhihong