Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Year-To-Date for 4 years (2009-2012)

I've a table with four years data. Is there any code to obtain partial sums for each year to show at the last four rows in the same table?

2 Replies
hic
Former Employee
Former Employee

Try putting relative months in your master calendar. http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

HIC

Not applicable
Author

simply take

years field and value field as dimension and take expression Aggr(sum(value),year)

then go to presentation tab and select dimension value then check on radio button of show partial sum