topic Re: YYYYMM to Quarter-Year in QlikView

topic Re: YYYYMM to Quarter-Year in QlikView https://community.qlik.com/t5/QlikView/YYYYMM-to-Quarter-Year/m-p/917986#M318242 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">='Q'&</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Ceil</SPAN>(<SPAN style="color: #0000ff;">right</SPAN>('201501',2)/3)&'-'&<SPAN style="color: #0000ff;">Left</SPAN>('201501',4)   -> Q1-2015</SPAN></P></BODY></HTML> Tue, 28 Jul 2015 13:57:03 GMT antoniotiman 2015-07-28T13:57:03Z YYYYMM to Quarter-Year https://community.qlik.com/t5/QlikView/YYYYMM-to-Quarter-Year/m-p/917985#M318241 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>need to convert the below to quarter-Year</P><P></P><P>201501</P><P>201502</P><P>201503</P><P></P><P>expected result: <STRONG>Q1-2015</STRONG> and so on</P><P></P><P>any ideas?</P><P></P><P>Kind Regards,</P><P>Olle</P><P><BR /> </P></BODY></HTML> Tue, 28 Jul 2015 13:39:12 GMT https://community.qlik.com/t5/QlikView/YYYYMM-to-Quarter-Year/m-p/917985#M318241 2015-07-28T13:39:12Z Re: YYYYMM to Quarter-Year https://community.qlik.com/t5/QlikView/YYYYMM-to-Quarter-Year/m-p/917986#M318242 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">='Q'&</SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Ceil</SPAN>(<SPAN style="color: #0000ff;">right</SPAN>('201501',2)/3)&'-'&<SPAN style="color: #0000ff;">Left</SPAN>('201501',4)   -> Q1-2015</SPAN></P></BODY></HTML> Tue, 28 Jul 2015 13:57:03 GMT https://community.qlik.com/t5/QlikView/YYYYMM-to-Quarter-Year/m-p/917986#M318242 antoniotiman 2015-07-28T13:57:03Z