Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
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!

1 Solution

Accepted Solutions
Peter_Cammaert

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

View solution in original post

1 Reply
Peter_Cammaert

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

View solution in original post