Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
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