Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

Accumulation

Scenario, i have a five years set of data in a table that is display in monthly.

Jan - 2008

Feb - 2008

.

.

.

Dec - 2008

Jan - 2009

.

.

.

Mar - 2013

I need to create an accumulative column of values in year basic. meaning that once it hit the december of  a particular year, it will reset back to 0 for jan - 2009

thanks!

10 Replies
Anonymous
Not applicable

Hi

Please find the attached qvw.

The 'ValueNew'  Field can be obtained using this..

Expression level i am not sure...

Regards

Revathy