topic Converting string yyyy-QQ to YYYY in QlikView https://community.qlik.com/t5/QlikView/Converting-string-yyyy-QQ-to-YYYY/m-p/1052015#M929984 <HTML><HEAD></HEAD><BODY><P>I have values in a table 2016-Q1,<SPAN style="font-size: 13.3333px;">2016-Q2,<SPAN style="font-size: 13.3333px;">2016-Q3,<SPAN style="font-size: 13.3333px;">2016-Q4 and its associated counts.I would like to convert this as YYYY to get the counts for total year.Could anybody suggest the way to achive it.I have tried min string&nbsp; but not successful</SPAN></SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Converting string yyyy-QQ to YYYY https://community.qlik.com/t5/QlikView/Converting-string-yyyy-QQ-to-YYYY/m-p/1052015#M929984 <HTML><HEAD></HEAD><BODY><P>I have values in a table 2016-Q1,<SPAN style="font-size: 13.3333px;">2016-Q2,<SPAN style="font-size: 13.3333px;">2016-Q3,<SPAN style="font-size: 13.3333px;">2016-Q4 and its associated counts.I would like to convert this as YYYY to get the counts for total year.Could anybody suggest the way to achive it.I have tried min string&nbsp; but not successful</SPAN></SPAN></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Converting-string-yyyy-QQ-to-YYYY/m-p/1052015#M929984 Anonymous 2020-11-25T16:16:04Z Re: Converting string yyyy-QQ to YYYY https://community.qlik.com/t5/QlikView/Converting-string-yyyy-QQ-to-YYYY/m-p/1052016#M929985 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P>left(fieldname, 4) as fieldName</P></BODY></HTML> Thu, 10 Mar 2016 20:44:10 GMT https://community.qlik.com/t5/QlikView/Converting-string-yyyy-QQ-to-YYYY/m-p/1052016#M929985 oknotsen 2016-03-10T20:44:10Z