Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wizardo
Creator III
Creator III

Loading scientific values from CSV

Hi,

i have a csv with values in scientific notation, for example:   5.15062E+12

qhwn i open this CSV in EXCEL and change the cell format to Number i get this value: 5150615600780

which is the correct value

but when i load the CSV file into qlikview it loads in the E+ format 5.15062E+12

and when i change it to number in the object properties NUMBERS tab

it shows this:5150620000000

how can i load it so it shows the correct value like in excel: 5150615600780

thanks

Daniel

6 Replies
PrashantSangle

Hi,

use evaluate()

regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
Not applicable

Can u upload the .csv file with few data rows so that I can check.

Anonymous
Not applicable

use text() at script while loading from Excel into QV and then convert it into number, like:

text(YourFieldName) as YourFieldName

wizardo
Creator III
Creator III
Author

use evaluate() how?

can you give an example?

Thanks

Daniel

swuehl
MVP
MVP

Daniel,

if your csv file really shows values like

5.15062E+12


I doubt that there are any means to get a higher precision using any tool (even Excel).

Either your file format is not a text file showing above text value, but containing some numeric representation also, or the excel formatting is screwed up.

PrashantSangle

Hi,

like evaluate(fieldName)

for more details, read below article

Evaluate() Function

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂