Monthly rolling time

[#1]

Dear Qlikview community,

I need your help with the following issue.

I am developing a report for TurnOver warehouse.

The TurnOver has been defined as follow-> TurnOver=Sales value past 12 month/Current warehouse value.

For Current warehouse value I have a table that gives me the "snapshot" (this comes from a qwd).

For Sales Value I have a join between two tables containing all sales from 2009 until now.

The report will run every end of month and what I need to have is the sold quantity for each material. This will be the sold quantity in the current month + 11 prior month 11 sales.

Example: for May 2013 I need the sold quantity in May + the sold quantity from June 2012 until now.

For June 2012 I need the sold quanityt in June 2013 + the sold quantity from July 2012 until now.

How can I do this?

If you need more information or details please let me know.

Thank you for your precious help!!

[jonathan_dau]

Hi,

I think you can achieve this by using a set analysis:

Sum({<Date = {">=$(=monthstart(addmonths(today(),-11)))<=$(=Monthend(today()))"}>} Sales Value)

Hope that helps.

Jonathan

[jonathan_dau · Accepted solution]

And if you want to use the selected date of your choice you have to change today() by a GetSelectedField(Date) for example if your Date is a Date field (hope you understand).

Jonathan

[#4]

Thank you for your help.
I'll try and let you know