topic Item code problem in QlikView https://community.qlik.com/t5/QlikView/Item-code-problem/m-p/946371#M325957 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a Item code field in excel in which numeric and alphanumeric both items are coming , my problem is that when I load excel data into Qlikview then only numeric items are showing alphanumeric item is not showing. I'm unable to understand why happening like this,</P><P></P><P>Please anyone help me out.</P><P></P><P>Item codes are like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="94"><TBODY><TR><TD class="xl63" height="20" width="94">ItemCode</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">0104000013I</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000013</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000014</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000015</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000016</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000017</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000018</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">0104000045I</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000016</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000019</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000014</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000030</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000017</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000026</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000032</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000033</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000034</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000022</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000023</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000026</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000027</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000030</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 14 Sep 2015 13:53:38 GMT Anonymous 2015-09-14T13:53:38Z Item code problem https://community.qlik.com/t5/QlikView/Item-code-problem/m-p/946371#M325957 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a Item code field in excel in which numeric and alphanumeric both items are coming , my problem is that when I load excel data into Qlikview then only numeric items are showing alphanumeric item is not showing. I'm unable to understand why happening like this,</P><P></P><P>Please anyone help me out.</P><P></P><P>Item codes are like this</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="94"><TBODY><TR><TD class="xl63" height="20" width="94">ItemCode</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">0104000013I</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000013</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000014</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000015</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000016</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000017</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000018</TD></TR><TR><TD class="xl66" height="20" style="border-top: none;">0104000045I</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000016</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000019</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000014</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000030</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000017</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000026</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000032</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000033</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000034</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000022</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000023</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000026</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000027</TD></TR><TR><TD class="xl67" height="20" style="border-top: none;">104000030</TD></TR></TBODY></TABLE></BODY></HTML> Mon, 14 Sep 2015 13:53:38 GMT https://community.qlik.com/t5/QlikView/Item-code-problem/m-p/946371#M325957 Anonymous 2015-09-14T13:53:38Z Re: Item code problem https://community.qlik.com/t5/QlikView/Item-code-problem/m-p/946372#M325958 <HTML><HEAD></HEAD><BODY><P>use Text(ItemCode) as ItemCode</P></BODY></HTML> Mon, 14 Sep 2015 13:59:42 GMT https://community.qlik.com/t5/QlikView/Item-code-problem/m-p/946372#M325958 sasiparupudi1 2015-09-14T13:59:42Z