Trigonometric Functions

Trigonometric functions are designed to perform trigonometric operations.

This article will cover the basic principles of working with these functions in the data load editor, including:

  • The general function syntax
  • Working with trigonometric functions in the data load editor

For a complete, up-to-date list of trigonometric functions, please see the Qlik Sense help pages here.

Note that trigonometric functions can also be used in visualisations.

The trigonometric function syntax

Not surprisingly, the general function syntax varies depending on the function. In this section, we will use an example function and decipher its syntax. This understanding will then help you read the syntax of other functions.

Example: Sin

The Sin() function returns the sine of the input provided.

Copy code 


sin( x )

The rules for reading the function syntax are as follows:

  1. The function name itself is first and all the parameters you need to enter go between brackets: ().
  2. The various elements you will need to enter are separated by commas. In this function, the only element is x. This is the value to find a sine of.
  3. Anything between square brackets [] is an optional parameter. In this function, there are no optional parameters.

An example of this function being used would be:

Copy code 


Sin(67)

How to use trigonometric functions in the data load editor

Here are some important points on using trigonometric functions in the data load editor:

  • All of the functions can be used throughout the whole load script, not just within a LOAD or SELECT statement
  • The functions can be nested and combined with other types of functions
  • These functions are quite niche so for your average business, they aren’t likely as useful as other functions