topic Problem with accumulative columns in QlikView

Problem with accumulative columns

Thu, 15 Jul 2010 21:14:51 GMT

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.

Problem with accumulative columns

mike_garcia — Fri, 16 Jul 2010 04:01:10 GMT

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.

Problem with accumulative columns

mike_garcia — Fri, 16 Jul 2010 04:02:50 GMT

[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.

Problem with accumulative columns

Fri, 16 Jul 2010 07:24:01 GMT

Thank you very much, Mike, it works!