need help on accumulative totals

[#1]

Hi All,

I need help on Accumulative totals.

I have an year field having values  from 2000 to 2015. and i have customers id's for years.

now my requirement is like when i select any year in list box it should display that year and previous 3 years and the years should display cumulative count of customer id's.

for ex: if i select 2006 the line chart should display 2006,2005,2004,2003 as dimentional values and 2003 year should display value "total count  of customer id's from 2000 to 2003 and 2004 should display count of customer id's from 2000 to 2004 like that 2006 should display count of customer id's from 2000 to 2006.

Thanks in Advance

[ramoncova06]

check this post

Accumulative Sums

[#3]

Hi Ramon,

Thanks for your reply along with the totals i have to display only 3 previous years along with selected year.

Kindly have a look on that also.

Thanks

[ramoncova06]

then you could use the examples in this post QlikView App: Dates, Date Ranges and Set Analysis