Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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
Hi,
Please check this
http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/10/relative-calendar-fields
Thanks