YTD, MTD with out using Master Calender

[Anonymous]

There are many posts on YTD, MTD which are using ID's,Is there a way to do with out creating flag's/Mastercalender for YTD, MTD?? 

I have tried but could not find desired results. please check sample file here..

[#2]

Hi Praveena,

I am pretty new to qlikview so have not really got a chance to study scripting so this is currently the formulas that I use to do a year on year comparison.  It works for me.

=num(sum({<FullDate={">31/05/2013<=$(ThisYearDate)"}>}Turnover),'$#,##0.00')

=num(sum({<FullDate={">31/05/2012<=$(LastYearDate)"}>}Turnover),'$#,##0.00')

variables

ThisYearDate

AddYears(Date(Max({<Turnover = {">0"}>} FullDate),))

LastYearDate

addyears(Date(Max({<Turnover = {">0"}>} FullDate),),-1)

Thanks,

Julian