topic Re: Convert year and month to Quarters in QlikView

Convert year and month to Quarters

sherryxuelee — Sat, 16 Nov 2024 02:49:31 GMT

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

Re: Convert year and month to Quarters

Frank_Hartmann — Sat, 03 Aug 2019 17:00:04 GMT

try this:

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

Re: Convert year and month to Quarters

Brett_Bleess — Mon, 26 Aug 2019 20:49:15 GMT

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