topic Re: Field with leading zeros in QlikView https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618712#M681826 <HTML><HEAD></HEAD><BODY><P>write:</P><P></P><P>Repeat('0', 10 - len(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SAKNR</SPAN>)) &amp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SAKNR</SPAN> as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SAKNR</SPAN></P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 09 Apr 2014 09:55:49 GMT alexandros17 2014-04-09T09:55:49Z Field with leading zeros https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618711#M681825 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en"><SPAN class="hps">I have a</SPAN> <SPAN class="hps">(probably)</SPAN> <SPAN class="hps">simple problem</SPAN><SPAN>:</SPAN></SPAN></P><P class="almost_half_cell"></P><DIV dir="ltr"><SPAN lang="en"><SPAN class="hps">In SAP</SPAN><SPAN>, I have two</SPAN> <SPAN class="hps">tables.</SPAN> <SPAN class="hps">The</SPAN> <SPAN class="hps">first</SPAN> <SPAN class="hps">gives me</SPAN> <SPAN class="hps">the account</SPAN> <SPAN class="hps">number field</SPAN> <SPAN class="atn hps">(</SPAN>SAKNR) <SPAN class="hps">10 digits,</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">the second</SPAN> <SPAN class="hps">between</SPAN> <SPAN class="hps">six</SPAN> <SPAN class="hps">and nine</SPAN> <SPAN class="hps">points.</SPAN> <BR /><SPAN class="hps">I want</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">SAKNR</SPAN> <SPAN class="hps">field</SPAN> <SPAN class="hps">generally have</SPAN> <SPAN class="hps">10 digits</SPAN> <SPAN class="hps">and</SPAN> <SPAN class="hps">leading zeros.</SPAN> <BR /><SPAN class="hps">example:</SPAN> <BR /><SPAN class="hps">0000628461</SPAN> <BR /><SPAN class="hps">0000047933</SPAN> </SPAN></DIV><DIV dir="ltr"><SPAN lang="en">not</SPAN></DIV><DIV dir="ltr"><SPAN lang="en">628461</SPAN></DIV><DIV dir="ltr"><SPAN lang="en">47933<BR /><SPAN class="hps">I tried</SPAN> <SPAN class="hps">it</SPAN> <SPAN class="hps">with the</SPAN> <SPAN class="hps">num</SPAN> <SPAN class="hps">#</SPAN> <SPAN class="hps">statement, but</SPAN> <SPAN class="hps">that does not work</SPAN> <SPAN class="hps">somehow</SPAN>.</SPAN></DIV><DIV dir="ltr"><BR /><SPAN class="short_text" lang="en"><SPAN class="hps">Can</SPAN> <SPAN class="hps">someone please</SPAN> <SPAN class="hps">help me</SPAN>? <BR /><SPAN class="hps">Thank you.</SPAN></SPAN></DIV><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></DIV><DIV dir="ltr"><SPAN class="short_text" lang="en"><SPAN class="hps">Peter<BR /></SPAN></SPAN></DIV><DIV dir="ltr"><P></P></DIV></BODY></HTML> Wed, 09 Apr 2014 09:53:45 GMT https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618711#M681825 shawnklar 2014-04-09T09:53:45Z Re: Field with leading zeros https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618712#M681826 <HTML><HEAD></HEAD><BODY><P>write:</P><P></P><P>Repeat('0', 10 - len(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SAKNR</SPAN>)) &amp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SAKNR</SPAN> as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">SAKNR</SPAN></P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 09 Apr 2014 09:55:49 GMT https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618712#M681826 alexandros17 2014-04-09T09:55:49Z Re: Field with leading zeros https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618713#M681827 <HTML><HEAD></HEAD><BODY><P>Try with Num function</P><P>Num(<SPAN class="hps" style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SAKNR</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> </SPAN>, '0000000000') AS SAKNR</P><P></P><P>Hope it helps</P></BODY></HTML> Wed, 09 Apr 2014 09:59:23 GMT https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618713#M681827 CELAMBARASAN 2014-04-09T09:59:23Z Re: Field with leading zeros https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618714#M681828 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like this</P><P></P><P>LOAD</P><P>Dim1,</P><P>Dim2,</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Text(Repeat('0', 10 - len(</SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SAKNR</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">)) &amp; </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SAKNR)</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"> as </SPAN><SPAN style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SAKNR</SPAN></P><P>FROM DataSource;</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 09 Apr 2014 09:59:54 GMT https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618714#M681828 jagan 2014-04-09T09:59:54Z Re: Field with leading zeros https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618715#M681831 <HTML><HEAD></HEAD><BODY><P>Num(example,'0000000000') as example</P></BODY></HTML> Wed, 09 Apr 2014 10:00:56 GMT https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618715#M681831 MK_QSL 2014-04-09T10:00:56Z Re: Field with leading zeros https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618716#M681833 <HTML><HEAD></HEAD><BODY><P>Hai Peter.</P><P>Try It This One</P><P>Num(<SPAN lang="en"><SPAN class="hps">SAKNR</SPAN></SPAN>,'0000000000')</P></BODY></HTML> Wed, 09 Apr 2014 10:21:09 GMT https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618716#M681833 arjunkrishnan 2014-04-09T10:21:09Z Re: Field with leading zeros https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618717#M681835 <HTML><HEAD></HEAD><BODY><P>Thank you.</P><P>All of your solutions help me.</P><P></P><P>This is really a great community <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Peter</P></BODY></HTML> Wed, 09 Apr 2014 10:24:29 GMT https://community.qlik.com/t5/QlikView/Field-with-leading-zeros/m-p/618717#M681835 shawnklar 2014-04-09T10:24:29Z