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: 
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