topic Re: Accumulation backwards in QlikView

Accumulation backwards

Tue, 08 Apr 2014 03:23:19 GMT

Hi,

I am trying to accumulate my chart based on below() values instead of the normal above() values.

rangesum(below(count([id]),0,14-RowNo()))

I have to hard code the max number (14) of row in my chart in order to do that.

Is there any way to get the max number of rows? Or is there a better way to do this reverse accumulation without chaing the sorting?

Tue, 08 Apr 2014 04:30:01 GMT

can you add a screenshot of what you want to achieve?

Tue, 08 Apr 2014 05:49:51 GMT

The code:

rangesum(below(count([id]),0, 14 -RowNo()))

already done what I have wanted, but I do not want to hardcode the number 14 in the code

Anonymous — Tue, 08 Apr 2014 05:58:39 GMT

have you tried the noofrows() chart inter-record function to replace the 14? (I assume 14 here is the number of rows in the chart.

Tue, 08 Apr 2014 06:13:08 GMT

Great, it works!

nizamsha — Tue, 08 Apr 2014 07:05:01 GMT

=RangeSum(Below( sum(No),0,NoOfRows()))

Thanks

Jeremy Lai

Tue, 08 Apr 2014 07:39:22 GMT

This works better

Tue, 08 Apr 2014 07:43:03 GMT

if it will be helpful maybe try function numsum