
Not applicable
2013-07-01
11:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12 months rolling growth rate
Hello,
I am trying to build the following expression:
- depending on date selection the application would return sum of SALES from last 12 months AND from 12 months a year ago. This would enable me to calculate rolling YtY growth rate afterwards.
My calendar column structure looks like this:
1. data - MM/DD/YYYY
2. Year - YYYY
3. month - oct, sept, etc.
4. day - DD
5. Quarter - Q1, Q2 etc
6. month year - oct YYYY, sept YYYY etc
Any ideas how to the expression should look like?
Thank you in advance
Przemek
2,612 Views
1 Reply


Partner - Specialist II
2013-07-01
11:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Please check this
http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields
Thanks
900 Views
