Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
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',
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