Table Script Functions

Table functions give information about the data table currently being read.

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

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

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

The table 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: NoOfRows

The NoOfRows() function returns the number of rows in a previously loaded table.

Copy code 


NoOfRows(table_name)

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 table_name. This is the name of the table in which you want to count the rows.
  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 


NoOfRows('CUSTOMERS')

The resulting field would return the number of rows in my ‘customers ‘CUSTOMERS’ table.

How to use table functions in the data load editor

Here are some important points on using table 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
  • The functions are particularly useful for monitoring app purposes or to be used as variables during the script execution