This section describes functions related to exponential and logarithmic calculations. All functions can be used in both the load script and in chart expressions.
In the functions below, the parameters are expressions where x and y
should be interpreted as real valued numbers.
The natural exponential function, e^x, using the natural logarithm e
as base. The result is a positive number.
exp(x
)
Examples and results:
exp(3) returns 20.085.
The natural logarithm of x.
The function is only defined if x>
0. The result is a number.
log(x
)
Examples and results:
log(3) returns 1.0986
The common logarithm (base 10) of x.
The function is only defined if x>
0. The result is a number.
log10(x
)
Examples and results:
log10(3) returns 0.4771
Returns x
to the power of y. The result
is a number.
pow(x,y
)
Examples and results:
pow(3, 3) returns 27
x squared (x to the power of 2).
The result is a number.
sqr (x )
Examples and results:
sqr(3) returns 9
Square root of x. The function
is only defined if x >= 0.
The result is a positive number.
sqrt(x
)
Examples and results:
sqrt(3) returns 1.732
Join the Analytics Modernization Program
Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com
