topic Issue with Rowno(Total) with rangesum below function in QlikView

Issue with Rowno(Total) with rangesum below function

Wed, 07 Mar 2012 17:11:12 GMT

I am having an issue using rowno(total) in a rangesum below function. The following is my expression:

RangeSum( below (sum({<[Cat ID]={'INV_WIP'}>} balance),0,RowNo(TOTAL)))

The records start out correct and I work from the bottom up, however (See image) when it gets to a certain row it no longer is correct.

The lines are showing what it is currently doing using rownow(total)

At the top of the chart the records are completely wrong. This is a balance sheet so flowing numbers from the bottom to the top is required to get the correct ending balances.

Expression results are covered due to confidentiality.

Issue with Rowno(Total) with rangesum below function

swuehl — Wed, 07 Mar 2012 17:37:55 GMT

Not sure if I understand, the image you attached seems ok to me. Rownumber is continuous and always incremented by one. I don't understand the lines at the right, probably they refer to expression values that your need to hide?

Maybe you need to rethink the use of below with rowno(total), I assume you want to add up all values that are below a certain line, but using rowno() you will miss more and more lines as soon as you get over the middle line.

Issue with Rowno(Total) with rangesum below function

Wed, 07 Mar 2012 18:01:33 GMT

I was able to get it to work using NoOfRows() instead.

That was my aim, basically a full accumulation, but reversed. NoOfRows() returns the total rows in the table so it sums everything correctly.