topic Re: adding up data during load in QlikView

adding up data during load

Wed, 04 Sep 2013 13:52:52 GMT

Hi,

is it possible to add up data during the LOAD process ?

There is certain Data which has to add up, but the source provides only the amount per month

F.e.

tmp_table:

LOAD

ID_item,

'0' as Added_Amount // initializing the Collumn

next_Table:

LOAD

ID_item,

Amount,

Amount+Added_Amount as Added_Amount

of course this example doesnt really work, because the script would have to look in the last recent data of the item.

Any suggestions ?

Gysbert_Wassenaar — Wed, 04 Sep 2013 14:00:10 GMT

I think you want something like this:

Table:

LOAD

ID_item,

Amount,

rangesum(peek('Added_Amount'),Amount) as Added_Amount

FROM ...somewhere...;

Wed, 04 Sep 2013 14:00:46 GMT

Can you do that in the next step?? load all the data, and then join it with a new column that do the sum??

Or maybe build a new table at the end, that group by ID_Item and do the sum of AMOUNT??

do you have an example?

Wed, 04 Sep 2013 14:34:51 GMT

tried that, didn't work because it cant "remember" the sum from the data-set before the current one.

join only seems to work if adding or calculationg data of the current set or one linked to it.