Fiscal Calendar YTD Query - Please Help

[#1]

Hi Qlik Community,

I am new to this and this is my first post. It would be very helpful if you could please explain the following.

I am trying to use a Fiscal year calendar where the year starts in December and I have used the following for Current YTD and Prior YTD.

     inyeartodate(TempDate, $(varToday), 0, 12) * -1  AS CurYTDFlag, 

     inyeartodate(TempDate, $(varToday), -1, 12) * -1 AS LastYTDFlag

The only problem is that as of today my data is only for YTD end of May. When it calculates the Prior YTD it counts data all the way to today's date last year. How do i make the above script to stop at end of previous month - which in this case is May 2013. I just want the above to calculate the YTD from Dec 2012 to May 2013 and Dec 2011 to may 2012.

Thanks,

Harsha

[marcus_sommer]

What don't work, which results do you received? Possibly with a little changes it will work. Perhaps it is better you gives us a small example app.

- Marcus