topic Re: leading zeros in QlikView https://community.qlik.com/t5/QlikView/leading-zeros/m-p/454649#M169630 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Are you using like calculation for SKU value.. If not means, try </P><P></P><P>Load&nbsp; text(SKU) as SKU,Code from tablename;</P><P></P><P>Hope it helps</P></BODY></HTML> Thu, 25 Oct 2012 15:06:02 GMT MayilVahanan 2012-10-25T15:06:02Z leading zeros https://community.qlik.com/t5/QlikView/leading-zeros/m-p/454648#M169629 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps"></SPAN><SPAN class="hps">Hi:</SPAN></P><P><SPAN class="hps"></SPAN></P><P><SPAN class="hps">When I load</SPAN> <SPAN class="hps">the following</SPAN> <SPAN class="hps">data</SPAN> <SPAN class="hps">from a txt file</SPAN>:</P><P></P><P><SPAN class="hps">SKU</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Code</SPAN></P><P><SPAN class="hps">034000240005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15710</SPAN></P><P><SPAN class="hps">00034000240005</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">15828</SPAN></P><P></P><P><SPAN class="hps">The result</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">QV</SPAN> <SPAN class="hps">for the</SPAN> <SPAN class="hps">SKU</SPAN> <SPAN class="hps">is</SPAN>:</P><P></P><P><SPAN class="hps">SKU</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Code</SPAN></P><P><SPAN class="hps">034000240005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">15710</SPAN></SPAN></P><P><SPAN class="hps">034000240005&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">15828</SPAN> </SPAN></P><P></P><P><SPAN class="hps">How</SPAN> <SPAN class="hps">I can</SPAN> <SPAN class="hps">fix this?</SPAN></P></BODY></HTML> Thu, 25 Oct 2012 14:58:21 GMT https://community.qlik.com/t5/QlikView/leading-zeros/m-p/454648#M169629 2012-10-25T14:58:21Z Re: leading zeros https://community.qlik.com/t5/QlikView/leading-zeros/m-p/454649#M169630 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Are you using like calculation for SKU value.. If not means, try </P><P></P><P>Load&nbsp; text(SKU) as SKU,Code from tablename;</P><P></P><P>Hope it helps</P></BODY></HTML> Thu, 25 Oct 2012 15:06:02 GMT https://community.qlik.com/t5/QlikView/leading-zeros/m-p/454649#M169630 MayilVahanan 2012-10-25T15:06:02Z Re: leading zeros https://community.qlik.com/t5/QlikView/leading-zeros/m-p/454650#M169631 <HTML><HEAD></HEAD><BODY><P>Thanks</P></BODY></HTML> Thu, 25 Oct 2012 15:26:10 GMT https://community.qlik.com/t5/QlikView/leading-zeros/m-p/454650#M169631 2012-10-25T15:26:10Z