topic Last Date in Quarter help in QlikView

Last Date in Quarter help

Tue, 18 Mar 2014 16:16:42 GMT

Hi All,

I am trying to get the last date in the quarter. How do I convert the following pseudo code to Qlikview?

Function LastDateInQuarter([Year] number, [Quarter] number) As Date

TrueYear = Year + 2000
LastDateInQuarter = LAST_DAY(TO_DATE(Quarter*3||"-01-"||TrueYear,'mm-dd-yyyy'))

End Function LastDateInQuarter

Any suggestions?

Thank you.

MarcoWedel — Tue, 18 Mar 2014 16:21:19 GMT

you could use something like

Date(Floor(QuarterEnd(any Timestamp in this quarter)))

regards

Marco

MK_QSL — Tue, 18 Mar 2014 16:31:07 GMT

Load

Date,

QuarterEnd(Date) as QTREND

Inline

[

Date

01/01/2014

05/01/2014

10/02/2014

15/03/2014

27/04/2014

];