Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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