Skip to main content

New to Qlik Sense

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

Skip the ticket, Chat with Qlik Support instead for instant assistance.
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