Qlik Sense Exponential and Logarithmic Functions With Syntax
Placement-ready Courses: Enroll Now, Thank us Later!
1. Objective
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.
Have a look at Qlik Sense Histogram Visualization
The syntax of exp() function
exp(x)
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.
For example,
exp(3) returns 20.085.
ii. log() function
Technology is evolving rapidly!
Stay updated with DataFlair on WhatsApp!!
This function gives the natural logarithm of x where x>0.
The syntax for log() function:
log(x)
For example,
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(x)
For example,
log10(3) returns 0.4771
Do you know about Qlik Sense Data Model
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(x,y)
For example, Â
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(x)
For example,
sqr(3) returns 9
sqr(4) returns 16
Let’s revise Qlik Sense Selections
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(x)
For example,
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.
3. Conclusion
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 –Â
Qlik Sense Treemap Visualizations
Did you like our efforts? If Yes, please give DataFlair 5 Stars on Google