Scientific Notation

[#1]

Hi all,

Having a problem here, i have a field that is returning scientific notation values:

I've tried num(CoardCode), text(CoardCode), text(CardCode&Chr(32)) etc. I don't want to go to the source and change it, i want to change it in Qlikview. Is there a function that gets rid of scientific notation in the script or in a calculated dimension?

Thanks.

[#2]

Not sure why num() is not working .Did you try changing the 'Number Format settings' for the expression? try to set it to number there and see if it works

[#3]

Its a dimension though, it doesn't come up in the number tab.

[#4]

dimensions formats can be modified in settings->document properties->number

[#5]

Ok cool tried that and still returns scientific notation. I'm bringing it from a csv file if that helps.

[tresesco]

Hi Richard,

could you please upload the sample qvw file?

--tresesco

[jonathandienst]

Richard

Could you upload the csv file as well. Or at least the first 20 lines or so.

Jonathan

[Anonymous]

The problem is the length of the numbers. Check out JohnW's post under Wiki on QlikView calculation (can't remember the exact name).

Script:

Load
F1,
Num(F1) as NumF1;
LOAD * INLINE [
F1
9.71E+23
4.65E+14
7.21E+13
3.23E+5
];

Table box:

F1 NumF1
3.23E+5 323000
7.21E+13 72100000000000
4.65E+14 4.65e+014
9.71E+23 9.71e+023

[#9]

I've uploaded a sample on my original post

[#10]

It won't allow me to upload a csv file