Solved: Re: How to acumulate a column by LOAD Script? - Qlik Community

Report Inappropriate Content · ‎2012-06-25

Hi Folks,

I have a little problem with LOAD Script.

I have a Excel sheet like this:

And I would like to acumulate the column "Period in Use", but I can´t do it in script!!

I'd tried using the function above in Load Script, but it is not run correctly what I want.

I would like transform that datas in a new table like this:

Because I need to use the column Acumulate for a Simple Graph Table.

I don´t want to do it on a Graph Bar Table or Graph Pivot...

Have anyone of you a idea?

Thank you so much.

swuehl · ‎2012-06-25

Rodrigo,

try using the peek() function, not above(), like

Acc:

LOAD Date,

Hour,

[Period in Use],

interval(rangesum(peek(Accumulated),[Period in Use])) as Accumulated

FROM

(html, codepage is 1252, embedded labels, table is @1);

swuehl · ‎2012-06-25

Rodrigo,

try using the peek() function, not above(), like

Acc:

LOAD Date,

Hour,

[Period in Use],

interval(rangesum(peek(Accumulated),[Period in Use])) as Accumulated

FROM

(html, codepage is 1252, embedded labels, table is @1);

Report Inappropriate Content · ‎2012-06-25

Perfect, my friend!!

I'd tried with peek() but incorrectly!

Your script runs ok!!

Thank you so much!