Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
uko223
Contributor III
Contributor III

RangeSum on Specific Rows

How can I create an expression that range sums on every 7 rows. For example, I am trying to get the table to sum the total of each week and then reset. For column CY WTD Currently, the expression I am using sums the total of all the weeks. 

if([Fiscal - Flag Current PTD]='Y',
RangeSum(Above(
TOTAL
Column(1),0, RowNo(TOTAL)))))

I just need this expression to only rangesum 7 rows up. 

3-14-2019 1-54-45 PM.jpg

 

0 Replies