Problem with accumulative columns

[#1]

Hi,

I have a problem with a pivot table.

The value of the columns is the value of the column plus the accumulative value of columns before. I try this with the function Before but I don't obtain the result I need.

The values of original expression are:

Month 1 2 3 4 5

1000 2000 3000 4000 5000

What I get:

Month 1 2 3 4 5

1000 3000 5000 7000 90000

But what I need is:

Month 1 2 3 4 5

1000 3000 6000 10000 15000

I need your help, any ideas?

Thank you very much,

O.Iglesias.

[mike_garcia · Accepted solution]

This is what you need:

=RangeSum(Before(Sum(IMPORTE), 0, ColumNo()))

What it is telling QlikView to do is: Evaluate Sum(IMPORTE) in all previous columns of my table, starting from this point (zero), and a for a number of x Columns (Result of ColumnNo()).

Hope this Helps.

Mike.

[mike_garcia]

[quote user="Mike García"]Evaluate Sum(IMPORTE) in all previous columns of my table, starting from this point (zero), and a for a number of x Columns (Result of ColumnNo()).

Sorry, I missed something: "AND sum all the results". So it should say:

Evaluate Sum(IMPORTE) in all previous columns of my table, starting from this point (zero), and a for a number of x Columns (Result of ColumnNo()) AND sum all the results.

Mike.

[#4]

Thank you very much, Mike, it works!