Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi there.
Try setting your desired numeric format for the field on the "numbers" tab before exporting.
Kind regards,
Ernesto.
Sounds like excel automatically formatting rather than something Qlikview is doing to be honest. Look to adjust the format in Excel maybe
Thanks. I tried all but nothing working. Any help please to set in Qlikview script itself.
Thanks. any help please in number tab?
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.
BR
Serhan
Looks like a precision limit in excel.