Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

YYYYMM to Quarter-Year

Hi,

need to convert the below to quarter-Year

201501

201502

201503

expected result: Q1-2015 and so on

any ideas?

Kind Regards,

Olle


1 Solution

Accepted Solutions
antoniotiman
Honored Contributor III

Re: YYYYMM to Quarter-Year

='Q'&Ceil(right('201501',2)/3)&'-'&Left('201501',4)   -> Q1-2015

View solution in original post

1 Reply
antoniotiman
Honored Contributor III

Re: YYYYMM to Quarter-Year

='Q'&Ceil(right('201501',2)/3)&'-'&Left('201501',4)   -> Q1-2015

View solution in original post