topic Re: ID in QlikView

ID

rolandg1881 — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

Sorry for my bad english i am from Austria! 😉

I have the following problem:

I use Qlikview 12. I have in the script a SQL query where i select Product Data and one of this is the Product_ID

The Product ID on the SQL Server looks like this after a query 100300030000015560

In Qlikview it looks like this 10020002e+17 and i dont know why.

I tried to change the number settings but nothing happens.

Has anyone an idea what i can do to get the right format of the id?

Thank you

and greetings from Austria

Roland

Re: ID

jonathandienst — Thu, 21 Feb 2019 08:02:30 GMT

Qlik thinks this is a number field and Qlik numerics can be up to 14 digits, so that is why it is converting the value to scientific notation. This value should be treated as text, so add a Text() function when you first load this value:

Load Text(Product_ID) as Product_ID, ...

This will prevent Qlik treating this field as a numeric.

Re: ID

rolandg1881 — Thu, 21 Feb 2019 16:48:03 GMT

Hi!

Thank you for the answer.

I had a other solution. in the SQL query i convert the ID.

Example: CAST(PK_id AS CHAR(30))RKopfID

that works! And now also the connections between the tables work.

Greetings Roland