topic Re: Add trailing spaces to value in QlikView https://community.qlik.com/t5/QlikView/Add-trailing-spaces-to-value/m-p/430845#M702542 <HTML><HEAD></HEAD><BODY><P>Thank you!&nbsp; that was perfect!!!</P></BODY></HTML> Fri, 21 Sep 2012 17:49:01 GMT 2012-09-21T17:49:01Z Add trailing spaces to value https://community.qlik.com/t5/QlikView/Add-trailing-spaces-to-value/m-p/430843#M702540 <HTML><HEAD></HEAD><BODY><P>We need to add trailing spaces to values where the len() is less than 18.&nbsp; Is this possible.</P><P></P><P>IF len([Profile Identifier]) &lt; 18&nbsp; </P><P></P><P>THEN </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; add <SPAN style="text-decoration: underline;">18&nbsp; - len(len([Profile Identifier])</SPAN>&nbsp; SPACES to the end of the text([Profile Identifier])</P><P></P><P>As [Profile Identifier]</P></BODY></HTML> Fri, 21 Sep 2012 17:30:42 GMT https://community.qlik.com/t5/QlikView/Add-trailing-spaces-to-value/m-p/430843#M702540 2012-09-21T17:30:42Z Re: Add trailing spaces to value https://community.qlik.com/t5/QlikView/Add-trailing-spaces-to-value/m-p/430844#M702541 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this,</P><P></P><P>IF(len([Profile Identifier]) &lt; 18 , [Profile Identifier]&amp;Repeat(' ',18-len([Profile Identifier])),[Profile Identifier])</P><P></P><P>Hope it helps</P></BODY></HTML> Fri, 21 Sep 2012 17:35:33 GMT https://community.qlik.com/t5/QlikView/Add-trailing-spaces-to-value/m-p/430844#M702541 MayilVahanan 2012-09-21T17:35:33Z Re: Add trailing spaces to value https://community.qlik.com/t5/QlikView/Add-trailing-spaces-to-value/m-p/430845#M702542 <HTML><HEAD></HEAD><BODY><P>Thank you!&nbsp; that was perfect!!!</P></BODY></HTML> Fri, 21 Sep 2012 17:49:01 GMT https://community.qlik.com/t5/QlikView/Add-trailing-spaces-to-value/m-p/430845#M702542 2012-09-21T17:49:01Z