topic Problem with rangesum in QlikView

Problem with rangesum

Tue, 06 Oct 2009 18:08:25 GMT

Hi,

I have a problem using rangesum function. I don´t know what function i have to use.

My problem is as follow:

I have a pivot table with 2 dimensions,and 3 expressions (A,B,A*B),

I´m using this formula in A*B

if(dimensionality()<2,
RangeSum(above(A*B,1,NoOfRows())),
A*B
)

but doesn´t works,

How can I get the sum of the above rows?

Tue, 06 Oct 2009 19:23:22 GMT

Hello José,

please see the attached example.

Good luck!

Rainer

Tue, 06 Oct 2009 23:11:40 GMT

Ok, Thanks.

Now it work´s fine