topic Re: Concatenating string values together in QlikView https://community.qlik.com/t5/QlikView/Concatenating-string-values-together/m-p/895073#M311600 <HTML><HEAD></HEAD><BODY><P>You closing parentheses for the LEN function should be after <PRE></PRE></P></BODY></HTML> Wed, 24 Jun 2015 18:45:30 GMT m_woolf 2015-06-24T18:45:30Z Concatenating string values together https://community.qlik.com/t5/QlikView/Concatenating-string-values-together/m-p/895072#M311599 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I'm concatenating a value - with the business rule if the length is greater than three characters, then place a decimal point in the middle, then concatenate the remaining text.&nbsp; Below is my formula</P><P></P><P>=IF(LEN([code] &gt; 3),concat(mid([code],3,1))&amp;'.'&amp;concat(mid([code],4,5)),<PRE>)</PRE></P><P></P><P>The Expression is 'OK', but I get an \\Error in Calculation as a result.&nbsp; What am I missing? </P><P></P><P>Thanks in advance</P></BODY></HTML> Wed, 24 Jun 2015 18:33:36 GMT https://community.qlik.com/t5/QlikView/Concatenating-string-values-together/m-p/895072#M311599 ngosz4074 2015-06-24T18:33:36Z Re: Concatenating string values together https://community.qlik.com/t5/QlikView/Concatenating-string-values-together/m-p/895073#M311600 <HTML><HEAD></HEAD><BODY><P>You closing parentheses for the LEN function should be after <PRE></PRE></P></BODY></HTML> Wed, 24 Jun 2015 18:45:30 GMT https://community.qlik.com/t5/QlikView/Concatenating-string-values-together/m-p/895073#M311600 m_woolf 2015-06-24T18:45:30Z