topic Re: accumulation in QlikView https://community.qlik.com/t5/QlikView/accumulation/m-p/835192#M998343 <HTML><HEAD></HEAD><BODY><P>Accumulation in a text object? Chart?? Do you have a sample??</P></BODY></HTML> Tue, 16 Jun 2015 18:20:37 GMT sunny_talwar 2015-06-16T18:20:37Z accumulation https://community.qlik.com/t5/QlikView/accumulation/m-p/835191#M998341 <HTML><HEAD></HEAD><BODY><P>I have 2 feilds named year, sales. If i select a year then i should get the accumulation of the sum of the sales of the previous 5 years dynamically? Example: if i slect year 2005 i should get the sales from 2000 to 2005 and the sales should be accumulated.</P></BODY></HTML> Tue, 16 Jun 2015 18:09:54 GMT https://community.qlik.com/t5/QlikView/accumulation/m-p/835191#M998341 2015-06-16T18:09:54Z Re: accumulation https://community.qlik.com/t5/QlikView/accumulation/m-p/835192#M998343 <HTML><HEAD></HEAD><BODY><P>Accumulation in a text object? Chart?? Do you have a sample??</P></BODY></HTML> Tue, 16 Jun 2015 18:20:37 GMT https://community.qlik.com/t5/QlikView/accumulation/m-p/835192#M998343 sunny_talwar 2015-06-16T18:20:37Z Re: accumulation https://community.qlik.com/t5/QlikView/accumulation/m-p/835193#M998344 <HTML><HEAD></HEAD><BODY><P>sum({&lt;year={"&gt;=$(=max(year)-5)&lt;=$(=max(year))"}&gt;}sales)</P></BODY></HTML> Tue, 16 Jun 2015 18:26:08 GMT https://community.qlik.com/t5/QlikView/accumulation/m-p/835193#M998344 maxgro 2015-06-16T18:26:08Z