Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

cancel
Showing results for 
Search instead for 
Did you mean: 
dmpilars
Partner
Partner

Incomplete Number

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!!

1 Solution

Accepted Solutions
sasiparupudi1
Master III
Master III

Try specifying the format to the number

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

FROM

your excel connection

View solution in original post

5 Replies
nawazuddin234
Contributor III
Contributor III

whats the measure ur using ?

dmpilars
Partner
Partner
Author

I'm only load data from excel. I try

Trim(num)

Num#(text(num))

Num#(num)

All of this read incomplete number.

sasiparupudi1
Master III
Master III

Try specifying the format to the number

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

FROM

your excel connection

stevedark
MVP
MVP

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
Master III
Master III

Have you got this working?