Extracting Year_Quarter from Date Field

[Bob07]

Hi,

I'm new to Qlik and I need help. I have a date field (purchase date) and want to extract the two fields (Year_quarter and Quarter_Start) using set expression or script. Kindly help.

Purchase Date	Year_quarter	Quarter_start
02/01/2023	2023-Q1	01/01/2023
15/11/2024	2024-Q4	01/10/2024

Thank you

[marcus_sommer]

Take a look on the inbuilt functions quartername() and quarterstart():

quarterstart - script and chart function | Qlik Cloud Help

[BrunPierre · Accepted solution]

These;

Year([Purchase Date]) & '-Q' & Ceil(Month([Purchase Date]) / 3) AS Year_quarter,
QuarterStart([Purchase Date]) as Quarter_Start

[Bob07]

Thank you BrunPierre. I appreciate. 

[Bob07]

Thank you Marcus, It was very helpful.