Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

accumulation

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.

2 Replies

Accumulation in a text object? Chart?? Do you have a sample??

MVP
MVP

sum({<year={">=$(=max(year)-5)<=$(=max(year))"}>}sales)