Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
slwasson
Partner
Partner

Accumulation in Pivot - need help!

I am unable to create YTD accumulation in a pivot.  I've read many previous threads on the topic, but nothing seemed to provide the answer I need.  Attached is a file containing some data, a pivot with incorrect YTD figures, and a screenshot from Excel of what the data should be.  Any help would be most appreciated!

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try as expression in your pivot table

=aggr(rangesum(above(sum(Sales),0,rowno())),Year,Date)

View solution in original post

3 Replies
swuehl
MVP
MVP

Try as expression in your pivot table

=aggr(rangesum(above(sum(Sales),0,rowno())),Year,Date)

View solution in original post

slwasson
Partner
Partner
Author

Thank you so very much - it works perfectly! 

marthacano01
Partner
Partner

Thank you!! you save my life!!