Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

repeat rangesum function for every x number of rows

In the example below I would like to use the rangesum function to sum the total for the Inbound column for every 7 records. Right now it is just a running total against the whole strait table. So I would like to calculated a sum for the Inbound column for rows 1-7, then 8-14, etc... Any ideas? Thanks.

error loading image

1 Solution

Accepted Solutions
Not applicable
Author

you should have a look at rangesum(above(myfield,1,7)) something like that

View solution in original post

2 Replies
Not applicable
Author

you should have a look at rangesum(above(myfield,1,7)) something like that

Not applicable
Author

That should work, but how to do you get it to repeat every 7 records? Thanks.