Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

mikevmalta
New Contributor III

strange data misinterpretation

Hi,

I have the following scenario:

I am reading codes from the database, where each code consists of numbers and letters. However there are some codes where the letter 'E' is being converted to the letter 'D'. Example:

Temp:

LOAD * INLINE

[

CUSTOMERID, CUSTOMERSTATUS, ADDRESS,                     CODE,

4879,                    Active,                    0030545578D3,                    84,

552829,                    Active,                    0030545578E3,                    35,

];

If you see the data in a table, you will find that both codes are interpreted to '0030545578D3'.

Do you know why this is happening?

Thanks in advance!

1 Solution

Accepted Solutions
MVP
MVP

Re: strange data misinterpretation

Testing also on QV11, after reloading your app, the code changes to the correct value.

I noticed that your field is tagged with numeric, integer, while my field is tagged as text, so probably QV automatic number interpretation in your version plays a role here.

Just an idea, try

Temp:

LOAD CUSTOMERID, CUSTOMERSTATUS, text(ADDRESS) as ADRESS, CODE INLINE

[

CUSTOMERID, CUSTOMERSTATUS, ADDRESS,         CODE,

4879,        Active,        0030545578D3,        84,

552829,        Active,        0030545578E3,        35,

];

4 Replies
MVP
MVP

Re: strange data misinterpretation

Sorry, I can't reproduce your issue using the above INLINE table. On which QV version are you?

mikevmalta
New Contributor III

Re: strange data misinterpretation

Hi,

Thanks for your reply.

I am using Qlikview 11. Please find attached my test .qvw.

Thanks

Michael

MVP
MVP

Re: strange data misinterpretation

Testing also on QV11, after reloading your app, the code changes to the correct value.

I noticed that your field is tagged with numeric, integer, while my field is tagged as text, so probably QV automatic number interpretation in your version plays a role here.

Just an idea, try

Temp:

LOAD CUSTOMERID, CUSTOMERSTATUS, text(ADDRESS) as ADRESS, CODE INLINE

[

CUSTOMERID, CUSTOMERSTATUS, ADDRESS,         CODE,

4879,        Active,        0030545578D3,        84,

552829,        Active,        0030545578E3,        35,

];

mikevmalta
New Contributor III

Re: strange data misinterpretation

Thanks a lot swuehl!

That did the trick