How can you load number data as is from excel to Qlikview?

[bill_mtc]

Hi,

Say I have 2009001000000060 in excel file in number format, I want it to display in Qlikview as is. But what happen is that in Qlikview it displays as 2.0090010000001e+015

What function to be used to solve this? So what would be the work around for this scenario?

Best Regards,

Bill

[bbi_mba_76]

Hi,

could you verify that in excel you have 2.0090010000001e+015 but it is showed as 2009001000000060?

[bill_mtc]

In excel I have 2009001000000060

In qlikview I have 2.0090010000001e+015

[#4]

I think, if you expand the field by dragging the cell towards the right, this problem would be solved.

[bill_mtc]

Kindly see attached file.

[jagan]

Hi,

I think this is an ID field, so you won't use this in any calculations or any aggregation functions on this.  So you can convert this to Text like this

LOAD

     Text(ID) AS ID

     ,

     ,

FROM DataSource;

Or

Check whether you are applying any formatting in Number tab and using this field as expression, then remove the formatting in Chart Properties -> Number tab -> Select Expression Default option.

Hope this helps  you.

Regards,

Jagan.

[#7 · Accepted solution]

Hi Bill,

Please see attached example. I have used number formatting in the load script.

[Carlos_Reyes]

I think the limit of characters for a number in QlikView is 14. That may be the reason why you can't see the whole number. If you won't aggregate this field values, you should use the TEXT function as Jagan suggests.

[bill_mtc]

Hi Daniel,

Thanks for this, yet all of the responses posted here are helpful. Among of them, you're response is what am lookin'.

Regards,

Bill