topic Function repeat doesn't work in QlikView https://community.qlik.com/t5/QlikView/Function-repeat-doesn-t-work/m-p/810062#M668335 <HTML><HEAD></HEAD><BODY><P>Hello, I am trying to use the function repeat in a macro section, but it doesn't work. Why?</P><P></P><P>c1_esp=21-len(c1)</P><P>temp_c1 = repeat(chr(32),c1_esp) &amp; c1</P><P></P><P>Thanks</P></BODY></HTML> Mon, 24 Nov 2014 17:02:50 GMT 2014-11-24T17:02:50Z Function repeat doesn't work https://community.qlik.com/t5/QlikView/Function-repeat-doesn-t-work/m-p/810062#M668335 <HTML><HEAD></HEAD><BODY><P>Hello, I am trying to use the function repeat in a macro section, but it doesn't work. Why?</P><P></P><P>c1_esp=21-len(c1)</P><P>temp_c1 = repeat(chr(32),c1_esp) &amp; c1</P><P></P><P>Thanks</P></BODY></HTML> Mon, 24 Nov 2014 17:02:50 GMT https://community.qlik.com/t5/QlikView/Function-repeat-doesn-t-work/m-p/810062#M668335 2014-11-24T17:02:50Z Re: Function repeat doesn't work https://community.qlik.com/t5/QlikView/Function-repeat-doesn-t-work/m-p/810063#M668336 <HTML><HEAD></HEAD><BODY><P>Repeat is a QlikView function. Macros use either vbscript or jscript.</P><P></P><P>vbscript doesn't have a repeat function.</P><P></P><P><A href="http://msdn.microsoft.com/en-us/library/t0aew7h6%28v=VS.84%29.aspx" title="http://msdn.microsoft.com/en-us/library/t0aew7h6%28v=VS.84%29.aspx">VBScript</A></P></BODY></HTML> Mon, 24 Nov 2014 17:11:09 GMT https://community.qlik.com/t5/QlikView/Function-repeat-doesn-t-work/m-p/810063#M668336 m_woolf 2014-11-24T17:11:09Z Re: Function repeat doesn't work https://community.qlik.com/t5/QlikView/Function-repeat-doesn-t-work/m-p/810064#M668337 <HTML><HEAD></HEAD><BODY><P>Ok, really... I forgot it.</P><P></P><P>Here the solution.</P><P></P><P>c1_esp=21-len(c1)</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">temp_c1 = string(c1_esp,chr(32)) &amp; c1</SPAN></P></BODY></HTML> Mon, 24 Nov 2014 18:49:53 GMT https://community.qlik.com/t5/QlikView/Function-repeat-doesn-t-work/m-p/810064#M668337 2014-11-24T18:49:53Z