Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jblomqvist
Contributor II

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

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?

2 Replies
pritamb89
Contributor

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

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

Capture4.PNG

MVP
MVP

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

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.

Community Browser