Functions Language

IsNull

The IsNull() function checks whether an element has no value assigned (i.e., it is null).

Related functions: IsElement, IsDateIsDefinedIsNullOrEmpty


Syntax:

IsNull(Element)
  • In the Quintessence Editor (Studio) using Python language, use: Qx.IsNull()
 See parameter descriptions

ElementAny input value.

Remarks:

  • It is generally recommended to use IsNullOrEmpty, which provides broader detection of missing values.

Examples:

The examples provided below are based on fictitious data for illustrative purposes only.

> Example 1: Check if each value in an array is null



Range:

12/23/2014
-1
ABCD
FALSE
(Blank cell)
46001

Formula:

return := IsNull(Range);

Result:

FALSE
FALSE
FALSE
FALSE
TRUE
FALSE