Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
AC187
Contributor II
Contributor II

Qlikview appening leading zeros to numeric values.

Hi all,

i have a data set where i have values of a field like

001234, 004223 , 002243 , 2241  in database.

however when i simply query the database table fetch data, all values are correct except the last one i.e 2241

it is loaded like 002241. There is no transformation on data nor on database nor on qlikview side still qlikview transforms the value like this amd since i am making a composite key out of that, the value breaks.

(I know the solution how to handle this, just want to know the reason behind this as this is very strange)

Labels (1)
2 Replies
settu_periasamy
Master III
Master III

Hi,

What is your source? SAP or SQL? 

Any mixedmode value added in your Connection string?

Check the environment variable also..

AC187
Contributor II
Contributor II
Author

The source is sql and there is no mixedmode value added in connection string.