Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.