Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
grajmca_sgp123
Creator
Creator
‎2018-06-14 05:34 AM

While exporting to CSV some values are convert into exponential

Hi,

While exporting to CSV some values are convert into exponential,but I want to show them as actual values instead of exponential when export to csv.

Could you guys suggest me how can we achieve this.

Example.214404450200110000 is converting to 2.14404E+17

1,042 Views
0 Likes
1 Reply
atoz1158
Creator II
Creator II
‎2018-06-14 07:06 AM

Rajesh

How are you looking at the csv file?

If you are using Excel then it could be that Excel is doing the conversion in the display for you, if so try opening the csv file with a text editor like notepad or even better Notepad++ so that you then see the exact format exported.


Adrian

959 Views
0 Likes