topic Re: Data showing incorrect when sending or exporting to excel from table box in QlikView

Data showing incorrect when sending or exporting to excel from table box

Fri, 16 Jan 2015 11:37:06 GMT

Hi,

I have data in table box as below

Data in table box
3536332219437005
6356536120134009

when I am sending or exporting to excel the data is changing as below

Incorrect
3536332219437000
6356536120134000

and sometimes it is showing as 3.9E+15

How to make data as it is even though if I send or export to excel? can anyone suggest me please.

Thanks.

consenit — Fri, 16 Jan 2015 11:45:42 GMT

Hi there.

Try setting your desired numeric format for the field on the "numbers" tab before exporting.

Kind regards,

Ernesto.

Fri, 16 Jan 2015 12:05:00 GMT

Sounds like excel automatically formatting rather than something Qlikview is doing to be honest. Look to adjust the format in Excel maybe

Fri, 16 Jan 2015 12:21:03 GMT

Thanks. I tried all but nothing working. Any help please to set in Qlikview script itself.

Fri, 16 Jan 2015 13:13:35 GMT

Thanks. any help please in number tab?

Anonymous — Fri, 16 Jan 2015 14:43:35 GMT

Hello,

As I wild guess, it should be related to Excel's number handling.

There is probably a difference between QlikView's number standards and Excel's. So you can search on that.

You know there are different standards on floating point, by that rationale I guess it is the same with large numbers.

Serhan

Anonymous — Fri, 16 Jan 2015 14:57:48 GMT

Looks like a precision limit in excel.