Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
bert_geraerts
Contributor II
Contributor II

Problem Rangesum when using dimension as column

Dear all,

I have a question regarding using rangesum in a pivot table, using columns.

I have an ordertable with for example 2 dimensions:

- ItemNr

- Date

- QTY

When I use a basic rangesum in a pivottable, I get the correct values:

rangesum(above(sum(QTY),0, rowno()))

However when I move the dimension "Date" from a row to a column, there is no more accumulation.

Is there any way of fixing this? 

Best Regards

1 Solution

Accepted Solutions
sunny_talwar

Try to change Above to Before and RowNo() to ColumnNo()

RangeSum(Before(Sum(QTY), 0, ColumnNo()))

View solution in original post

3 Replies
sunny_talwar

Try to change Above to Before and RowNo() to ColumnNo()

RangeSum(Before(Sum(QTY), 0, ColumnNo()))

Sergey_Shuklin
Specialist
Specialist

Hello!

Try to use ColumnNo() instead of RowNo().

bert_geraerts
Contributor II
Contributor II
Author

So stupid of me, I didn't even realise the ColumnNo was a possibility.

I always thought the rowno stoot for row in the table and not in the object itselve.

Thanks a lot