topic Re: Re: How to calculate running total/ average while loading data. in QlikView

How to calculate running total/ average while loading data.

Mon, 28 Oct 2013 11:09:16 GMT

Any simple way to calculate the running total/average as a calculated field while loading the data from the tables.

Mon, 28 Oct 2013 15:07:09 GMT

Following discussion is helpful

Anonymous — Mon, 28 Oct 2013 15:31:15 GMT

Zahoor

You can use the peek function in your load script to look at the previous row loaded.

This script code should give you inspiration.

AA :

LOAD * INLINE [

Value

];

BB:

load

[Value] ,

[Value] + if(peek(RunningTotal) > 0 , peek(RunningTotal) , 0) as RunningTotal

resident AA

;

drop table AA ;

Best Regards, Bill