Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have to make a report by using MTD & YTD concept :
Month-TO-Date(MTD)
In this report data is shown for till date of the current month, for the same date of the previous month, and the same date of the last year of same month.
For Eg : - Today is Mar,26 - so data is shown for Mar,2013(Till 26) , Feb,2013(till 26), Mar,2012(till 26)
Year - To-Date(YTD)
In this report data is shown from the begining of the month to the till date of current month and same for the previous months.
For Eg:- Today is Mar,26 - so data is shown from Jan,2013 to Mar,2013(Till 26) and From Jan,2012 to Mar,2012(Till 26).
Please reply ASP, and refer the attached File for Reference.
You'll find a number of examples of period over period reporting here on the community and in blogs.Some resources I would recommend are:
The book "Qlikview 11 for Developers"
http://iqlik.wordpress.com/2011/01/01/point-in-time-reporting-out-of-the-box/
http://qlikviewnotes.blogspot.com/2012/01/easy-period-analysis-using-qlikview.html
-Rob