Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Employee
Employee

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.

View solution in original post

7 Replies
Not applicable
Author

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

Not applicable
Author

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
Employee
Employee

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
Author

Great, it works!

table.PNG.png

nizamsha
Specialist II
Specialist II

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

Thanks

Jeremy Lai

Not applicable
Author

This works better

Not applicable
Author

if it will be helpful maybe try function  numsum