Qlik Sense Exponential and Logarithmic Functions With Syntax

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.

Qlik Sense Exponential and Logarithmic Functions With Syntax

Qlik Sense Exponential and Logarithmic Functions With Syntax

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

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

Reference for Qlik Sense

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.