QlikVIew is converting my text values into numbers? How to fix it?

[jblomqvist]

Hello,

I have a Excel column that looks like this:

%
<100%
<50%
50%
80%
>=75%
>50%

When I load it into QlikView it is converting 50%, 80%, 100% into 5, 8, and 1.

QlikView is treating this field as Mixed.

How can I stop it doing that?

[jerryyang756]

I have loaded the same data but It is showing in correct format.

You should check the number tab and uncheck If there is any selected

[Miguel_Angel_Baeyens]

You can always use a Text() function in the script while loading to make sure QlikView applies the literal value instead of the numerical one.