Data number format

[#1]

I'm experiencing a problem since the Qlikview 10 was installed on my computer. Some of my data numbers are in exponential format eg. 1,000,000 will be 1.0E+06. Qlikview 10 does not identify them as a number and displays zero.

Please help.

[pljsoftware]

Hi,

where your data is in exponential form, in souce data o in qlikview data?

[#3]

The souce data is in exponential form.

[Miguel_Angel_Baeyens]

Hello,

If the field is readable as a string "1,0E+06", then the following may work, although certainly roundabout

=Num(Left('1,0E+06', Index('1,0E+06', 'E') -1)) * Pow(10, TextBetween('1,0E+06', 'E+', ''))

Hope that helps.

[#5]

Yes, it is readable as a string. Where do I type that code can I do it in the script?

[Miguel_Angel_Baeyens]

Hello,

Yes, the idea is to use this code in the script:

Table:LOAD Field1, Num(Left(NumberField, Index(NumberField, 'E') -1) * Pow(10, TextBetween(NumberField, 'E+', ''))) AS NumberField;SQL SELECT Field1, NumberFieldFROM Database.Source;

Field in bold is your field with exponential values as strings.

Hope that helps.