Discussion board where members can get started with Qlik Sense.
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 :
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?
Go to Solution.
Try specifying the format to the number
LOAD Num(Num,'#,##0.0000000000000') As Num
your excel connection
whats the measure ur using ?
I'm only load data from excel. I try
All of this read 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!
Have you got this working?