Qlik Sense Exponential and Logarithmic Functions With Syntax
In our last Qlik Sense tutorial, we discussed Qlik Sense Counter Functions. Today, we will see Qlik Sense Exponential and Logarithmic Functions. So, this lesson discusses the functions we use for performing exponential and logarithmic operations on data values. We use such functions in making mathematical calculations. For explanatory purpose, we have used x and y as parameters used in the functions.
So, let’s start Qlik Sense Exponential and Logarithmic Functions tutorial.
2. Qlik Sense Exponential and Logarithmic Functions
i. exp() function
The exp() function is used to calculate the exponential value of an integer. It uses the natural logarithm e base which is the mathematical constant in ex. While using the exponential function, you only need to specify the value for x.
The syntax of exp() function
Where x is the number you want to convert as an exponential value calculated upon the base e. The result of this function is a positive number.
exp(3) returns 20.085.
ii. log() function
This function gives the natural logarithm of x where x>0.
The syntax for log() function:
log(3) returns 1.0986
iii. log10() function
This function returns the value of common logarithmic base 10 of x, where x>0 and is a number.
The syntax for log10() Function:
log10(3) returns 0.4771
iv. pow() function
This function is used to evaluate x to the power y for any two numbers as x and y. The number in the place of x will be the base number and y
The syntax for pow() Function:
pow(3, 3) returns 27, or
pow(3, 2) returns 9
v. sqr() function
This function returns the result of x squared i.e. x2 (x to the power 2).
The syntax for sqr() Function:
sqr(3) returns 9
sqr(4) returns 16
vi. sqrt() function
The sqrt() function calculates the square root of numbers. The x is a number which should be greater than 0 and the function returns a positive number.
The syntax for sqrt() function:
sqrt(2) returns 1.414
sqrt(3) returns 1.732
sqrt(9) returns 3
So, this was all in Qlik Sense Exponential and Logarithmic Functions. Hope you like our explanation.
Hence in this Qlik Sense Exponential and Logarithmic Functions tutorial, we discussed all the exponential and logarithmic functions that are there and can be used in the data load script. These functions must be used for basic mathematical operations as they have simple syntax and so, can be used conveniently.
Still, if any question regarding Qlik Sense Exponential and Logarithmic Functions, ask in the comment tab.
See also –