Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Monthly rolling time

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

1 Solution

Accepted Solutions
jonathan_dau
Contributor III
Contributor III

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

View solution in original post

3 Replies
jonathan_dau
Contributor III
Contributor III

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
Contributor III
Contributor III

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

Not applicable
Author

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