topic zeros ? in QlikView https://community.qlik.com/t5/QlikView/zeros/m-p/632985#M678288 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one Column ContractID..</P><P></P><P>Values:</P><P>000238</P><P>000567</P><P>000786</P><P>001234</P><P>001435</P><P>028978</P><P></P><P>I want to remove zeros how can i write in back end scripting..</P></BODY></HTML> Wed, 14 May 2014 12:22:19 GMT 2014-05-14T12:22:19Z zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632985#M678288 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have one Column ContractID..</P><P></P><P>Values:</P><P>000238</P><P>000567</P><P>000786</P><P>001234</P><P>001435</P><P>028978</P><P></P><P>I want to remove zeros how can i write in back end scripting..</P></BODY></HTML> Wed, 14 May 2014 12:22:19 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632985#M678288 2014-05-14T12:22:19Z Re: zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632986#M678289 <HTML><HEAD></HEAD><BODY><P>Num(ContractID) as ContractID</P></BODY></HTML> Wed, 14 May 2014 12:24:19 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632986#M678289 tresB 2014-05-14T12:24:19Z Re: zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632987#M678290 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><STRONG>replace(ltrim(replace(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ContractID</SPAN>,'0',' ')),' ','0') </STRONG></SPAN><STRONG>as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">ContractID</SPAN></STRONG></P><P></P><P>This was taken from a previous discussion:</P><P></P><P><A href="https://community.qlik.com/thread/9447">Remove Leading Zeros from Field while loading</A></P></BODY></HTML> Wed, 14 May 2014 12:27:26 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632987#M678290 2014-05-14T12:27:26Z Re: zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632988#M678291 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use like this below :</P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>PurgeChar<SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">ContractID</SPAN><SPAN style="font-size: 8pt;"> , '0') </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">New<SPAN style="color: #800000; font-size: 8pt;">ContractID</SPAN><SPAN style="font-size: 8pt;"> </SPAN></SPAN></P><P> </P><P><SPAN style="color: #800000; font-size: 8pt;">OR</SPAN></P><P> </P><P> </P><P><SPAN style="color: #0000ff; font-size: 8pt;">&nbsp; </SPAN></P><P>num<SPAN style="font-size: 8pt;">(<SPAN style="color: #800000; font-size: 8pt;">ContractID</SPAN><SPAN style="font-size: 8pt;"> </SPAN></SPAN><SPAN style="font-size: 8pt;">) </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">as</SPAN><SPAN style="font-size: 8pt;"> <SPAN style="color: #800000; font-size: 8pt;">New<SPAN style="color: #800000; font-size: 8pt;">ContractID</SPAN><SPAN style="font-size: 8pt;"> </SPAN></SPAN></SPAN></P><P></P></BODY></HTML> Wed, 14 May 2014 12:28:01 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632988#M678291 dmohanty 2014-05-14T12:28:01Z Re: zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632989#M678292 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>May be like this.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 14 May 2014 12:34:27 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632989#M678292 ashfaq_haseeb 2014-05-14T12:34:27Z Re: zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632990#M678293 <HTML><HEAD></HEAD><BODY><P>Hi, try this:</P><P></P><P>REPLACE(LTRIM(REPLACE(FIELD, '0', ' ')), ' ', '0')as FIELD,</P><P></P><P></P><P>good luck</P><P></P><P>Fernando</P></BODY></HTML> Wed, 14 May 2014 12:36:34 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632990#M678293 fkeuroglian 2014-05-14T12:36:34Z Re: zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632991#M678294 <HTML><HEAD></HEAD><BODY><P>you can use:</P><P></P><P>num(youFieldName)</P><P></P><P>it will cut of leading zeros.</P><P></P><P>regards,</P><P>MT</P></BODY></HTML> Wed, 14 May 2014 12:38:00 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632991#M678294 2014-05-14T12:38:00Z Re: zeros ? https://community.qlik.com/t5/QlikView/zeros/m-p/632992#M678295 <HTML><HEAD></HEAD><BODY><P>You try this:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="_jivemacro_uid_14000739143036781 jive_text_macro jive_macro_code" jivemacro_uid="_14000739143036781"> <P>Data:</P> <P>LOAD Values, Num(Values,'0') AS Values_New INLINE [</P> <P>&nbsp;&nbsp;&nbsp; Values</P> <P>&nbsp;&nbsp;&nbsp; 000238</P> <P>&nbsp;&nbsp;&nbsp; 000567</P> <P>&nbsp;&nbsp;&nbsp; 000786</P> <P>&nbsp;&nbsp;&nbsp; 001234</P> <P>&nbsp;&nbsp;&nbsp; 001435</P> <P>&nbsp;&nbsp;&nbsp; 028978</P> <P>];</P> </PRE><P></P><P>Best Regards.</P><P>Tonial.</P></BODY></HTML> Wed, 14 May 2014 13:25:42 GMT https://community.qlik.com/t5/QlikView/zeros/m-p/632992#M678295 fernando_tonial 2014-05-14T13:25:42Z