Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rolandg1881
Creator
Creator

ID

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

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rolandg1881
Creator
Creator
Author

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