Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Cumulative YTD of the Highest Year Selected

So I want to show a cumulative total from month to month for the highest year selected and defaulting to the highest year when no year is selected. I have been able to make a non cumulative line with the code (month by month):

SUM({$< Year={$(=Max(Year))} >}[Customer Incidents])


but am struggling to make a cumulative version (Cumulative YTD).

This is what I have for it now: RANGESUM(ABOVE(TOTAL Sum([Customer Incidents]),0, ROWNO(TOTAL))). Unfortunately it compounds years instead of defaulting to the highest selected. Any help would be appreciated. Thanks!

1 Solution

Accepted Solutions

Try this

RangeSum(Above(TOTAL Sum({$<Year = {$(=Max(Year))}>} [Customer Incidents]), 0, RowNo(TOTAL)))

View solution in original post

3 Replies

Try this

RangeSum(Above(TOTAL Sum({$<Year = {$(=Max(Year))}>} [Customer Incidents]), 0, RowNo(TOTAL)))

View solution in original post

Or this

RangeSum(Above(Sum({$<Year = {$(=Max(Year))}>} [Customer Incidents]), 0, RowNo()))

Contributor III
Contributor III

This worked. Thanks so much.