topic Re: QlikSense rounding value during load script in App Development

QlikSense rounding value during load script

johnnyjohn — Thu, 17 Apr 2025 15:04:59 GMT

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

Re: QlikSense rounding value during load script

Vegar — Fri, 18 Apr 2025 05:44:57 GMT

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) ?

Re: QlikSense rounding value during load script

BrunPierre — Fri, 18 Apr 2025 09:07:06 GMT

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')

Re: QlikSense rounding value during load script

johnnyjohn — Wed, 23 Apr 2025 06:33:09 GMT

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

Re: QlikSense rounding value during load script

marcus_sommer — Wed, 23 Apr 2025 08:34:35 GMT

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 ?

Re: QlikSense rounding value during load script

johnnyjohn — Fri, 02 May 2025 08:45:44 GMT

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

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