QlikSense rounding value during load script

[johnnyjohn]

Been working with Qlik for 5 years, never seen this issue before. 

Loading data from a parquet file, all floats are rounded to 2dp when I add them as dimension. If I load the fields as TEXT(Field), the numbers come out ok, if I show them as measures, they are fine. 

What's going on here? How can I fix? There's hundreds of columns being imported that are impacted so I need a general fix, not just for that specific field. 

Thanks a lot 

[Vegar]

First thing to check is if the numbers are actually rounded or just presented with two decimals?

What happens if you agter you have loaded your [Field] into the data model create a filter pane with the dimension =num([Field],'0.0000')? Are the lost decimal turnimg up (like 1.2345) or are you getting two tailing zeros (like 1.2300) ?

[BrunPierre]

Could it be that the field is being treated as a dual value, causing the numeric representation to be rounded?

Without access to the actual data, perhaps forcing a numeric interpretation like this:

Num#(Field, '#,##0.000000000')

[johnnyjohn]

It does seem to be a display thing - so forcing the formatting on the field shows the decimal places as expected - but simply adding it as a dimension without any changes trims to 2 DP 

[marcus_sommer · Accepted solution]

Are there then multiple equally looking values within the dimensions - means that something like:

0.011
0.012

are shown ones as 0.01 or twice as 0.01 ?

[johnnyjohn]

Thanks, formatting them with this expression showed the numbers correctly, just a display thing. -

Num#(Field, '#,##0.000000000')