topic Re: Monthly rolling time in QlikView

Monthly rolling time

Wed, 15 May 2013 07:53:00 GMT

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!!

Re: Monthly rolling time

jonathan_dau — Wed, 15 May 2013 09:32:55 GMT

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

Re: Monthly rolling time

jonathan_dau — Wed, 15 May 2013 09:35:47 GMT

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

Re: Monthly rolling time

Fri, 17 May 2013 08:37:25 GMT

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