Numeric Text String Converted to Date

dbaksa_1 — Tue, 22 Jun 2010 13:06:34 GMT

I have a TEXT string of data sometimes represented as a numeric value which I am forcing to text during the load (See Code Below). For some reason some of the numeric values are being converted to a date by QlikView even though I'm forcing them to text and I cannot figure out why. We have looked at the source data which is stored in a JBA data source and we have looked at the HEX representation of the data and everything looks OK.

Does anyone have an ideas?

EXAMPLE: 0040203 converted to 01/25/10

EXAMPLE: 0040211 converted to 02/02/10

Sample Code:

WMSLotTracking:
LOAD
*,
TEXT("Lot Number") AS [Lot Number Text];
SQL SELECT *

FROM DATASOURCE.USA_VIEW_WMSLotTracking where "Lot Year" = 2010;

Numeric Text String Converted to Date

johnw — Tue, 22 Jun 2010 23:40:19 GMT

I am unable to duplicate the problem. See attached. I don't have any theory on how it could get confused.

Numeric Text String Converted to Date

Anonymous — Wed, 23 Jun 2010 01:08:09 GMT

Daniel,
Check in Document Properties, tab Number. Maybe the field is formatted as date there (?)

topic Numeric Text String Converted to Date in QlikView

Numeric Text String Converted to Date

Numeric Text String Converted to Date

Numeric Text String Converted to Date