topic Re: converter numeros in Brasil https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660125#M18806 <HTML><HEAD></HEAD><BODY><P>Boa tarde Valber.</P><P>Veja se este exemplo lhe atende.</P><P></P><P>Abs.</P></BODY></HTML> Tue, 09 Sep 2014 18:38:05 GMT rphpacheco 2014-09-09T18:38:05Z converter numeros https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660123#M18804 <HTML><HEAD></HEAD><BODY><P>Oi boa tarde! Eu estou querendo que meu campo traga zero a esquerda quando o nuúmero for menor que a quantidade de caracteres! Alguem pode me ajudar?</P><P></P><P>os campos estao vindo assim&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>cd_usuario</P><P>1</P><P>123</P><P>1234</P><P>12345</P><P></P><P>eu quero que venha assim</P><P>cd_usuario</P><P>00001</P><P>00123</P><P>01234</P><P>12345</P></BODY></HTML> Tue, 09 Sep 2014 18:28:12 GMT https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660123#M18804 2014-09-09T18:28:12Z Re: converter numeros https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660124#M18805 <HTML><HEAD></HEAD><BODY><P>O Qlikview quando identifica que o campo é numérico e possui zero a esquerda, ele sempre vai remover.</P><P>O que você pode fazer é transformar essa coluna em texto. Em seu script, faça Text(cd_usuario) as cd_usuario.</P></BODY></HTML> Tue, 09 Sep 2014 18:32:40 GMT https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660124#M18805 nicolett_yuri 2014-09-09T18:32:40Z Re: converter numeros https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660125#M18806 <HTML><HEAD></HEAD><BODY><P>Boa tarde Valber.</P><P>Veja se este exemplo lhe atende.</P><P></P><P>Abs.</P></BODY></HTML> Tue, 09 Sep 2014 18:38:05 GMT https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660125#M18806 rphpacheco 2014-09-09T18:38:05Z Re: converter numeros https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660126#M18807 <HTML><HEAD></HEAD><BODY><P>Olá, utilize o comando <STRONG><EM>Num()</EM></STRONG> no load de seu campo.</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_14102886247349474" jivemacro_uid="_14102886247349474"> <P>Num(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">cd_usuario</SPAN>, '00000') as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">cd_usuario</SPAN></P> </PRE><P></P><P>Qlikfique-se.</P><P>Tonial.</P></BODY></HTML> Tue, 09 Sep 2014 18:51:02 GMT https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660126#M18807 fernando_tonial 2014-09-09T18:51:02Z Re: converter numeros https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660127#M18808 <HTML><HEAD></HEAD><BODY><P>Olá Fernando,</P><P>no caso se o campo for de 14 carcteres, terei que colocar&nbsp; 14 zeros?</P><P>tipo assim:</P><P><SPAN style="color: #000000; font-family: Consolas, 'Courier New', Courier, mono, serif; font-size: 12px;">Num(cd_usuario, '00000000000000') as cd_usuario</SPAN></P></BODY></HTML> Tue, 09 Sep 2014 18:55:07 GMT https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660127#M18808 2014-09-09T18:55:07Z Re: converter numeros https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660128#M18809 <HTML><HEAD></HEAD><BODY><P>Isso mesmo.</P><P></P><P>Qlikfique-se.</P><P>Tonial.</P></BODY></HTML> Tue, 09 Sep 2014 19:00:35 GMT https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660128#M18809 fernando_tonial 2014-09-09T19:00:35Z Re: converter numeros https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660129#M18810 <HTML><HEAD></HEAD><BODY><P>Galera, muito obrigado!</P><P>as respostas foram úteis e rápidas!</P><P>Muito obrigado!</P></BODY></HTML> Tue, 09 Sep 2014 19:56:33 GMT https://community.qlik.com/t5/Brasil/converter-numeros/m-p/660129#M18810 2014-09-09T19:56:33Z