Incomplete Number

[dmpilars]

Hi!!!

I have a problem with my data, I have an Excel and this contains float numbers and when I try to read these  numbers qlik sense desktop read the numbers incomplete e.g.

My number : 1234567,1234567890123

My number after qlik sense desktop read it :

1234567,12345679

I need my number complete and I have load this like a number not a string.

How can I load that number full ? This occurs by default?

Thanks!!

[Anonymous]

whats the measure ur using ?

[dmpilars]

I'm only load data from excel. I try

Trim(num)

Num#(text(num))

Num#(num)

All of this read incomplete number.

[sasiparupudi1 · Accepted solution]

Try specifying the format to the number

LOAD Num(Num,'#,##0.0000000000000') As Num

FROM

your excel connection

[stevedark]

Are you sure that the number is incomplete, and it is not just being rounded when it is being displayed?

Try an expression of sum(Number) * 1000000 and see if the further decimals are actually present and just not shown.

When you come to display your numbers, if you need all those significant figures, you can provide a Custom number mask and provide the number of decimals you need, as sasiparupudi1‌ suggests.

If the number truly isn't loading, then you could create another sheet in Excel which has those values multiplied up (e.g. =A2*1000000) and then try loading from there instead.

Hope that helps!

Steve

[sasiparupudi1]

Have you got this working?