Discussion board where members can get started with QlikView.
I used the following Date functions in Qlikview:
YearEnd( date [, shift = 0 [, first_month_of_year = 1]] )
QuarterEnd( date [, shift = 0 [, first_month_of_year = 1]] )
MonthEnd( date [, shift = 0] )
Do you know if there's something like that for Half Year end? Can you please advise a workaround for this?
Go to Solution.
if (Month(date) < 7, QuarterEnd(MakeDate(1, 6, Year(date))), YearEnd(date))
View solution in original post