Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Notation E interpreted as numerical with script variable ExponentNumberNotation=0

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
ToniKautto
Employee
Employee

Notation E interpreted as numerical with script variable ExponentNumberNotation=0

Last Update:

May 10, 2022 3:25:39 PM

Updated By:

Jamie_Gregory

Created date:

Nov 27, 2013 8:40:32 AM

Data with alphanumerical values are loaded into QlikView and Qlik Sense.

 

Environment:

Qlik Sense Enterprise on Windows 
QlikView 
Qlik Cloud 
Qlik Sense Business 

The script variable ExponentNumberNotation is set to 0, to disable interpretation of  E and D as exponential values. 

The same variable is applicable for Qlik Sense too.

SET ThousandSep=' ';
SET DecimalSep=',';

SET ExponentNumberNotation = 0;

LOAD * INLINE [
AlphaNumerical
1E1
2D2
3e3
4d4
];


The script above is expected to load the values as text, meaning that the numerical interpretation is Null.

Values loaded as text table representations.png


Instead, the loaded data still has numerical values for the notation E values.

Values loaded numerical values table representations.png

The reason for the observed issue is a product design limitation, which limits the usage of the script variable ExponentNumberNotation.

If ExponentNumberNotation=0 the decimal separator and thousands separators must be either dot or comma, in order to disable both D and E notation for exponential values. 




Resolution:


There are two different ways to resolve the issue.

  1. Change decimal and thousand separators so that they comply with the limitation
    SET ThousandSep=',';
    SET DecimalSep='.';​
    OR
    SET ThousandSep='.';
    SET DecimalSep=',';​
  2. Format the loaded value as text during load
    LOAD
       Text(AlphaNumercial) AS AlphaNumerical
    Inline [
    AlphaNumercial
    1E1
    2D2
    3e3
    4d4
    ];​
Labels (1)
Version history
Last update:
‎2022-05-10 03:25 PM
Updated by: