Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Item code problem

Hi All,

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,

Please anyone help me out.

Item codes are like this

ItemCode
0104000013I
104000013
104000014
104000015
104000016
104000017
104000018
0104000045I
104000016
104000019
104000014
104000030
104000017
104000026
104000032
104000033
104000034
104000022
104000023
104000026
104000027
104000030
1 Reply
sasiparupudi1
Master III
Master III

use Text(ItemCode) as ItemCode