Qlikview converting numeric values in text field to percentages

[#1]

Hi fellow Qlikviewers,

I'm having an issue with loading some data in from an Access query.  The field in question is formatted as text in the Access table and Query and contains both numbers, percentages and text e.g:

100%

> 98%

YES

No Target

0

4.5

etc

The field is used to show targets for KPI's in an easy to understand format and is not used for calculations.

Qlikview is turning all numerical values into % so the 0 values show as 0% when they are not in fact percentages.  We have loaded this data previously from an Excel worksheet and Qlikivew follows the format specified in the worksheet but it doesn't seem to want to do this from an access query and I can't find a way to force it to display what it is being asked to display.

The format in Qlikview is set to 'mixed'.

Any help would be greatly appreciated.

Many thanks

Tim

[Anonymous]

goto "Settings\Document\Number" where you can override the "mixed" datatype to the format you want e.g. integer

[#3]

maybe you can set the field as text using text function in load script..

=text(..) as ..