Convert year and month to Quarters

[sherryxuelee]

Hi All, I'm new to Qlik! How do i convert the below format to Quarters? I know how to do so if it is a date format... but the below isnt. Appreciate any help, thanks in advance!

Time_Year&Month

2017-01

2017-02

2017-03

[Frank_Hartmann]

try this:

='Q' & Ceil(Month(date#(Time_Year&Month,'YYYY-MM'))/3) 

[Brett_Bleess]

Sherry, just giving you one other thing along the lines of what Frank has already stated, but it might help fill in some gaps potentially...

https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157

If Frank's post worked, please consider using the Accept as Solution button on his post to give him credit for helping out as well.  If you did something different, consider posting that and you can then mark that as the solution as well...

Regards,
Brett