Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

dmpilars
New Contributor II

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

Tags (1)
1 Solution

Accepted Solutions
sasiparupudi1
Honored Contributor III

Re: Incomplete Number

Try specifying the format to the number

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

FROM

your excel connection

5 Replies
nawazuddin234
New Contributor III

Re: Incomplete Number

whats the measure ur using ?

dmpilars
New Contributor II

Re: Incomplete Number

I'm only load data from excel. I try

Trim(num)

Num#(text(num))

Num#(num)

All of this read incomplete number.

sasiparupudi1
Honored Contributor III

Re: Incomplete Number

Try specifying the format to the number

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

FROM

your excel connection

MVP
MVP

Re: Incomplete Number

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
Honored Contributor III

Re: Incomplete Number

Have you got this working?

Community Browser