summing over the period in a script

Wed, 26 Mar 2014 14:34:15 GMT

I've uploaded a table with several dimensions as shown below

I need to sum up "saldi" starting from the first period in a cumulative way, that's

1st period sum = saldi 1st period

2nd period sum = saldi 1st period + saldi 2nd period

3rd period sum = saldi 1st period + saldi 2nd period + saldi 3rd period...

... and so on

I'm in trouble because I'm not able to do it.

Thanks in advance

Claudio

Re: summing over the period in a script

stevedark — Wed, 26 Mar 2014 14:41:59 GMT

Your best bet may be to upload another dimension which deals which allows a single source value to appear in many periods.

The table would be something like:

Accumulate:

LOAD

Saldi,

Cumulative

INLINE [

Saldi,Cumulative

01,01

02,01

02,02

03,01

03,02

03,03

04,01

etc...

];

This way any value that exists in Saldi 03 is associated with cumulative periods 01, 02 and 03.

You may run into some issues with QlikView treating some of the values as strings and others as text - causing the associations not to work but you can probably work around this. You also have the issue that you could potentially have many years - do you know how you will want to accumulate this?

The accumulation table could be built in a nested loop, or driven from a spreadsheet with the join values.

Hope that gives you some pointers.

Steve

topic Re: summing over the period in a script in QlikView

summing over the period in a script

Re: summing over the period in a script