Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Load
Date,
QuarterEnd(Date) as QTREND
Inline
[
Date
01/01/2014
05/01/2014
10/02/2014
15/03/2014
27/04/2014
];
you could use something like
Date(Floor(QuarterEnd(any Timestamp in this quarter)))
regards
Marco
Load
Date,
QuarterEnd(Date) as QTREND
Inline
[
Date
01/01/2014
05/01/2014
10/02/2014
15/03/2014
27/04/2014
];