Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
khimhoe_sdm
Creator II
Creator II

Text Treated As Number

I have some product codes that are text, but treated as number/integer. Anyone know why?

The codes:-

7E02
8E12
7E22
8E32
8E36
8E42
8E46

Other codes in the same field are treated as text. Only the above are treated as number. (right aligned)

1 Solution

Accepted Solutions
tresesco
MVP
MVP

'E' is being treated as 'Exponent' (scientific notation). If you want this to be treated as text, try loading like:

Load

        Text(Field) as Field

View solution in original post

1 Reply
tresesco
MVP
MVP

'E' is being treated as 'Exponent' (scientific notation). If you want this to be treated as text, try loading like:

Load

        Text(Field) as Field

View solution in original post