topic repeat rangesum function for every x number of rows in QlikView https://community.qlik.com/t5/QlikView/repeat-rangesum-function-for-every-x-number-of-rows/m-p/240651#M91153 <HTML><HEAD></HEAD><BODY><P>you should have a look at rangesum(above(myfield,1,7)) something like that</P><P></P></BODY></HTML> Fri, 13 Nov 2009 23:30:41 GMT 2009-11-13T23:30:41Z repeat rangesum function for every x number of rows https://community.qlik.com/t5/QlikView/repeat-rangesum-function-for-every-x-number-of-rows/m-p/240650#M91152 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-595_sourceID:595" /></P></BODY></HTML> Fri, 13 Nov 2009 23:29:13 GMT https://community.qlik.com/t5/QlikView/repeat-rangesum-function-for-every-x-number-of-rows/m-p/240650#M91152 2009-11-13T23:29:13Z repeat rangesum function for every x number of rows https://community.qlik.com/t5/QlikView/repeat-rangesum-function-for-every-x-number-of-rows/m-p/240651#M91153 <HTML><HEAD></HEAD><BODY><P>you should have a look at rangesum(above(myfield,1,7)) something like that</P><P></P></BODY></HTML> Fri, 13 Nov 2009 23:30:41 GMT https://community.qlik.com/t5/QlikView/repeat-rangesum-function-for-every-x-number-of-rows/m-p/240651#M91153 2009-11-13T23:30:41Z repeat rangesum function for every x number of rows https://community.qlik.com/t5/QlikView/repeat-rangesum-function-for-every-x-number-of-rows/m-p/240652#M91154 <HTML><HEAD></HEAD><BODY><P>That should work, but how to do you get it to repeat every 7 records? Thanks.</P></BODY></HTML> Fri, 13 Nov 2009 23:42:19 GMT https://community.qlik.com/t5/QlikView/repeat-rangesum-function-for-every-x-number-of-rows/m-p/240652#M91154 2009-11-13T23:42:19Z