Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem with rangesum

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),

error loading image

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?

1 Solution

Accepted Solutions
Not applicable
Author

Hello José,

please see the attached example.

Good luck!

Rainer

View solution in original post

2 Replies
Not applicable
Author

Hello José,

please see the attached example.

Good luck!

Rainer

Not applicable
Author

Ok, Thanks.

Now it work´s fine