topic Data number format in QlikView

Data number format

Fri, 25 Mar 2011 12:42:08 GMT

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.

Data number format

pljsoftware — Fri, 25 Mar 2011 12:58:50 GMT

Hi,

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

Data number format

Fri, 25 Mar 2011 13:06:14 GMT

The souce data is in exponential form.

Data number format

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 13:32:59 GMT

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.

Data number format

Fri, 25 Mar 2011 13:41:32 GMT

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

Data number format

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 13:59:59 GMT

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.