Date to year quarter

[dandaanilreddy]

Hello Qlik developers,

I have a date field in which i have the values like 20170630 , 20170930, 20171231. I want to convert this as 2017Q2, 2017Q3 and 2017Q4 . Any idea's ?

[sunny_talwar · Accepted solution]

Try this

Year(Date#(DateField, 'YYYYMMDD')) & 'Q' & Ceil(Month(Date#(DateField, 'YYYYMMDD'))/3) as Quarter

[dandaanilreddy]

Thanks bro.