Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Current YTD Flag creation for an odd start and end date

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?

Thank you

1 Solution

Accepted Solutions
Highlighted

Re: Current YTD Flag creation for an odd start and end date

May be this

If(TempDate >= (YearStart(Today(), 0, 😎 + 27) and TempDate <= Today() 1, 0) as Flag

View solution in original post

2 Replies
Highlighted

Re: Current YTD Flag creation for an odd start and end date

May be this

If(TempDate >= (YearStart(Today(), 0, 😎 + 27) and TempDate <= Today() 1, 0) as Flag

View solution in original post

Highlighted
Contributor II
Contributor II

Re: Current YTD Flag creation for an odd start and end date

Thank you Sunny,

If(TempDate >= (YearStart(Today(), 0, 8)) + 27 and TempDate <= Today(), 1, 0) AS Flag

Works perfectly.