topic implicit conversion varchar to number in QlikView https://community.qlik.com/t5/QlikView/implicit-conversion-varchar-to-number/m-p/217191#M70436 <HTML><HEAD></HEAD><BODY><P>I have in my data base a varchar filed which contain a product code ('000004'). Qlikview diplay this field as a number format (right position) and the field which start with '0' are truncate if it conntain more 4 '0'.</P><P>As result i get two codes for the same product!</P><P>Code Date base Code QliK view</P><P>'0000027' ' 00027'</P><P>'00027' '00027'</P></BODY></HTML> Fri, 24 Sep 2010 10:16:35 GMT 2010-09-24T10:16:35Z implicit conversion varchar to number https://community.qlik.com/t5/QlikView/implicit-conversion-varchar-to-number/m-p/217191#M70436 <HTML><HEAD></HEAD><BODY><P>I have in my data base a varchar filed which contain a product code ('000004'). Qlikview diplay this field as a number format (right position) and the field which start with '0' are truncate if it conntain more 4 '0'.</P><P>As result i get two codes for the same product!</P><P>Code Date base Code QliK view</P><P>'0000027' ' 00027'</P><P>'00027' '00027'</P></BODY></HTML> Fri, 24 Sep 2010 10:16:35 GMT https://community.qlik.com/t5/QlikView/implicit-conversion-varchar-to-number/m-p/217191#M70436 2010-09-24T10:16:35Z implicit conversion varchar to number https://community.qlik.com/t5/QlikView/implicit-conversion-varchar-to-number/m-p/217192#M70437 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can use the Text function for this implicit conversion in script while loading the data, which will be as under:-</P><P>Text([Product Code]) AS [Product Docde]</P><P>Please revert back for any futher query.</P></BODY></HTML> Fri, 24 Sep 2010 10:29:16 GMT https://community.qlik.com/t5/QlikView/implicit-conversion-varchar-to-number/m-p/217192#M70437 2010-09-24T10:29:16Z implicit conversion varchar to number https://community.qlik.com/t5/QlikView/implicit-conversion-varchar-to-number/m-p/217193#M70438 <HTML><HEAD></HEAD><BODY><P>Thank you very much! Its working now <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Fri, 24 Sep 2010 10:45:47 GMT https://community.qlik.com/t5/QlikView/implicit-conversion-varchar-to-number/m-p/217193#M70438 2010-09-24T10:45:47Z