topic Small precision values loading probelm in QlikView

Small precision values loading probelm

Tue, 21 Oct 2014 15:08:00 GMT

Hello, I want to load the small precision values from DB and I got zero values only. Here is the example:

I have value in the db table like -1E-7 and qlikview loads this values as -0.

I want load those exact values & display either number format or DB table format .

Please help me ...

cesaraccardi — Tue, 21 Oct 2014 15:35:00 GMT

Hi,

Have you tried using the num# function when loading the field from DB? Something like this:

num#(Field, '############') as Field

You probably will need the num function to specify the resulting format as well:

num(num#(Field, '############'), '############') as Field

PS: I am not sure about the mask you should use here.

Kind Regards,

Cesar

maxgro — Tue, 21 Oct 2014 17:34:28 GMT

this isn't in a load but it should works