Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jblomqvist
Specialist
Specialist

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
jerryyang756
Creator
Creator

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

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.