topic slider nd accumulation in QlikView https://community.qlik.com/t5/QlikView/slider-nd-accumulation/m-p/797584#M1050202 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>my requirment is like bar chart displaying&nbsp; 10&nbsp; yrs historical data.whenever client elects the particular yer like 1993.he needs to get accumulation of last 3yrs like 92,91 and 93.how to solve this requirement.</P><P></P><P>value should pass dynmically to the slider.</P></BODY></HTML> Mon, 10 Nov 2014 08:32:07 GMT 2014-11-10T08:32:07Z slider nd accumulation https://community.qlik.com/t5/QlikView/slider-nd-accumulation/m-p/797584#M1050202 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>my requirment is like bar chart displaying&nbsp; 10&nbsp; yrs historical data.whenever client elects the particular yer like 1993.he needs to get accumulation of last 3yrs like 92,91 and 93.how to solve this requirement.</P><P></P><P>value should pass dynmically to the slider.</P></BODY></HTML> Mon, 10 Nov 2014 08:32:07 GMT https://community.qlik.com/t5/QlikView/slider-nd-accumulation/m-p/797584#M1050202 2014-11-10T08:32:07Z Re: slider nd accumulation https://community.qlik.com/t5/QlikView/slider-nd-accumulation/m-p/797585#M1050203 <HTML><HEAD></HEAD><BODY><P>Try sum(Year={'&gt;$(=max(Year)-2)&lt;=$(=max(Year))'}Amount). If that's not the answer you're looking for then please post a document with data and an explanation.</P></BODY></HTML> Mon, 10 Nov 2014 10:55:37 GMT https://community.qlik.com/t5/QlikView/slider-nd-accumulation/m-p/797585#M1050203 Gysbert_Wassenaar 2014-11-10T10:55:37Z Re: slider nd accumulation https://community.qlik.com/t5/QlikView/slider-nd-accumulation/m-p/797586#M1050204 <HTML><HEAD></HEAD><BODY><P>if above gysbert answer is not working</P><P>u may try in chart level like</P><P>above(sum(amount),3))</P><P>or</P><P></P><P>accumation 3 steps back</P></BODY></HTML> Mon, 10 Nov 2014 10:59:34 GMT https://community.qlik.com/t5/QlikView/slider-nd-accumulation/m-p/797586#M1050204 2014-11-10T10:59:34Z