topic Re: strange data misinterpretation in QlikView

strange data misinterpretation

mikevmalta — Fri, 09 Aug 2013 08:24:54 GMT

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!

Re: strange data misinterpretation

swuehl — Fri, 09 Aug 2013 08:43:06 GMT

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

Re: strange data misinterpretation

mikevmalta — Fri, 09 Aug 2013 08:59:22 GMT

Hi,

Thanks for your reply.

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

Thanks

Michael

Re: strange data misinterpretation

swuehl — Fri, 09 Aug 2013 09:05:37 GMT

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,

];

Re: strange data misinterpretation

mikevmalta — Fri, 09 Aug 2013 09:55:18 GMT

Thanks a lot swuehl!

That did the trick