Qlikview appening leading zeros to numeric values.

[AC187]

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)

[settu_periasamy]

Hi,

What is your source? SAP or SQL? 

Any mixedmode value added in your Connection string?

Check the environment variable also..

[AC187]

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