Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Accumulation backwards

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?
accum.PNG.png

1 Solution

Accepted Solutions
jei
New Contributor II

Re: Accumulation backwards

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.

7 Replies
Not applicable

Re: Accumulation backwards

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

Not applicable

Re: Accumulation backwards

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

jei
New Contributor II

Re: Accumulation backwards

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.

Not applicable

Re: Accumulation backwards

Great, it works!

table.PNG.png

nizamsha
Valued Contributor II

Re: Accumulation backwards

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

Thanks

Jeremy Lai

Not applicable

Re: Accumulation backwards

This works better

Not applicable

Re: Accumulation backwards

if it will be helpful maybe try function  numsum