Qlik Sense Enterprise on Windows: Possible text misinterpretation

Albert1177 — Tue, 15 Oct 2024 16:44:48 GMT

Hello, as I'm developing an app which loads data via load * inline statement, I got an unexpected behavior from Qlik Sense (May 2024 SR6):

In my DLE I have the following code:

MyTable:

load * inline [
id_product, cod_product, value
27447, 1330600, 50000
697586, 13306E2, 10400
];

Loading data show no errors. I would expect the cod_product to be interpreted as text given the value '13306E2' in the second line. However, when I create a table and add those 3 fields, the cod_product shows strange values, i.e. 1330600 for all rows (see the picture):

In the data model viewer preview the same issue, and the tag is $numeric integer.
It looks like QS does not recognize the cod_product field data type value and assuming it is a number, it changes the value of id_product 27447 to 1330600 instead of 13306E2.
As a troubleshoot step, I have enclosed cod_product values into single or double quotes, with no success, still 1330600.
Any hints on how to mitigate that?
This applies to Qlik Sense Cloud also, I should be missing some steps.
Hint1: casting did not help either
Hint2: same happens when you load data via SQL from an ODBC connection.

Re: Qlik Sense Enterprise on Windows: Possible text misinterpretation

seanbruton — Tue, 15 Oct 2024 22:55:58 GMT

Hi,

To overcome this try

text(cod_product) as cod_product

Regards

Re: Qlik Sense Enterprise on Windows: Possible text misinterpretation

Albert1177 — Fri, 18 Oct 2024 07:55:34 GMT

Hi, that didn't help.
I believe that is due to how the QV/QS Engine stores data values. More on this:
https://community.qlik.com/t5/Official-Support-Articles/How-Is-Data-Stored-In-Qlik-Sense-And-QlikView/ta-p/1712436

topic Re: Qlik Sense Enterprise on Windows: Possible text misinterpretation in App Development

Qlik Sense Enterprise on Windows: Possible text misinterpretation

Re: Qlik Sense Enterprise on Windows: Possible text misinterpretation

Re: Qlik Sense Enterprise on Windows: Possible text misinterpretation