topic Prevent QlikSense from recognizing value as date in App Development

Prevent QlikSense from recognizing value as date

bubbleboy77 — Sat, 16 Nov 2024 02:05:16 GMT

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.

Re: Prevent QlikSense from recognizing value as date

fosuzuki — Tue, 23 Jun 2020 08:06:29 GMT

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.

Re: Prevent QlikSense from recognizing value as date

Or — Tue, 23 Jun 2020 08:22:15 GMT

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

Re: Prevent QlikSense from recognizing value as date

bubbleboy77 — Mon, 06 Jul 2020 13:01:17 GMT

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.

Re: Prevent QlikSense from recognizing value as date

fosuzuki — Mon, 06 Jul 2020 13:03:29 GMT

Can you share your script code?

Re: Prevent QlikSense from recognizing value as date

bubbleboy77 — Mon, 06 Jul 2020 13:03:34 GMT

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'?

Re: Prevent QlikSense from recognizing value as date

Or — Mon, 06 Jul 2020 14:41:06 GMT

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.