topic Re: Problem Rangesum when using dimension as column in QlikView

Problem Rangesum when using dimension as column

bert_geraerts — Fri, 19 Oct 2018 13:52:44 GMT

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

sunny_talwar — Fri, 19 Oct 2018 13:54:59 GMT

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

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

Sergey_Shuklin — Fri, 19 Oct 2018 13:55:33 GMT

Hello!

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

bert_geraerts — Fri, 19 Oct 2018 13:59:36 GMT

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