topic Scientific Notation in QlikView

Scientific Notation

Fri, 13 Aug 2010 08:50:00 GMT

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.

Scientific Notation

Fri, 13 Aug 2010 08:53:17 GMT

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

Scientific Notation

Fri, 13 Aug 2010 09:19:39 GMT

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

Scientific Notation

Fri, 13 Aug 2010 09:24:48 GMT

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

Scientific Notation

Fri, 13 Aug 2010 09:51:22 GMT

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

Scientific Notation

tresB — Fri, 13 Aug 2010 09:56:16 GMT

Hi Richard,

could you please upload the sample qvw file?

--tresesco

Scientific Notation

jonathandienst — Fri, 13 Aug 2010 10:13:05 GMT

Richard

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

Jonathan

Scientific Notation

Anonymous — Fri, 13 Aug 2010 10:26:00 GMT

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

Scientific Notation

Fri, 13 Aug 2010 10:28:22 GMT

I've uploaded a sample on my original post

Scientific Notation

Fri, 13 Aug 2010 10:29:03 GMT

It won't allow me to upload a csv file