This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
where your data is in exponential form, in souce data o in qlikview data?
The souce data is in exponential form.
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.
Yes, it is readable as a string. Where do I type that code can I do it in the script?
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.