Prevent QlikSense from recognizing value as date

[bubbleboy77]

Hello all, 

Working on a QlikSense app, pulling data from Oracle DB. 

In one of the fields the users may enter dates (in different formats), numbers or string - the DB field itself is Character.

When the data gets into QlikSense, the valid date values are automatically recognized as dates and are converted to numeric representation of date (like you'd have in Excel). 

My goal is to keep those values untouched - as they are in the database. For example '01/10/2019'. Any If functions or TEXT function that I tried, changed the value (for example to '1-10-19'). I'd like to have QlikSense to ignore the value and interpret all values in this field as simple string.

I thank you for any suggestions,

David.

[fosuzuki]

Have you tried using TEXT() in the data load script? It will not work in the front-end, as the field is probably defined as "mixed" in the datamodel.

[Or]

You could try untagging the field as '$date' and tagging it as '$text'.

[bubbleboy77]

Thank you! I tried that, with no luck.. 

I have a date '1/01/2019' in the DB, that's shown as '1-1-19' in QlikSense.

How can I have it remain as '1/01/2019'? 

Thanks again,

David.

[fosuzuki]

Can you share your script code?

[bubbleboy77]

Thank you Or, I tried this but with no luck yet.

Am I doing this correctly? 

At the UI application I wrote: 

Untag field INVOICE_NUMBER with '$date';
Tag field INVOICE_NUMBER with '$text';

I have a date '1/01/2019' in the DB, that's shown as '1-1-19' in QlikSense.

How can I have it remain as '1/01/2019'? 

[Or]

Your invoice number is a date? Possibly you are tagging the wrong field?

Tagging and untagging doesn't always solve these issues, but it is worth trying. If that doesn't solve your problem, I'm not really sure what else to try since you've already tried the obvious options such as using text(). Perhaps you could try concatenating an extra whitespace to the end of your string, which should (possibly) make it not read as a date.