Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data number format

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.

5 Replies
pljsoftware
Creator III
Creator III

Hi,

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

Not applicable
Author

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.

Not applicable
Author

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.