Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Is there Half Year End Date function in Qlikview?

Hello,

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?

Thanks!

Tags (3)
1 Solution

Accepted Solutions

Re: Is there Half Year End Date function in Qlikview?

if (Month(date) < 7, QuarterEnd(MakeDate(1, 6, Year(date))), YearEnd(date))

View solution in original post

1 Reply

Re: Is there Half Year End Date function in Qlikview?

if (Month(date) < 7, QuarterEnd(MakeDate(1, 6, Year(date))), YearEnd(date))

View solution in original post