Discussion board where members can get started with QlikView.
I am trying to get a current year to date flag set-up for a Master Calendar.
The issue I have is that the start date for the trade year is 28th August.
I cannot seem to find anything that will allow me to have the 28th August as the start day for the current YTD.
Is there a way I can define the 28th as the first day of the new calendar year and any date after that until today's date is flagged as a 1?
May be this
If(TempDate >= (YearStart(Today(), 0, 😎 + 27) and TempDate <= Today() 1, 0) as Flag
View solution in original post
Thank you Sunny,
If(TempDate >= (YearStart(Today(), 0, 8)) + 27 and TempDate <= Today(), 1, 0) AS Flag