sum for rolling -12 months (select only 1 month)

[#1]

I have two list

- values

- dates

I want to select a date (month/year) and then I need the =Sum(Values)  starting from my selected date to date-11 months. Please find attached my app, but I cannot get it working.

I already tried getfieldselections and addmonths without success, maybe you have a more sophisticated solution.

thanks a lot in advanced.

[Anonymous]

Check this post. There are some examples there.

Jonathan

[#3]

what do you want me to check? cant find a link or somethink else

[shree909 · Accepted solution]

Hi may be u can get some help from this  below link

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields

Thanks

[Anonymous]

Apologies. Forgot the link: http://community.qlik.com/message/162423#162423

Jonathan

[#6]

great, this lead to the right solution