I have a Excel column that looks like this:
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?
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
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.
Retrieving data ...