Menu
Amazon QuickSight
User Guide

isNull Function

isNull evaluates an expression to see if it is null. If the expression is null, isNull returns true, otherwise it returns false.

Syntax

Copy
isNull(expression)

Arguments

expression

The expression to be evaluated as null or not. It can be a field name like address1 or a call to another function that outputs a string.

Return Type

Boolean

Example

The following example evaluates the sales_amount field for null values.

Copy
isNull(sales_amount)

For the field values:

Copy
20.13 (null) 57.54

The following values are returned:

Copy
false true false