NULL value handling

When no data can be produced for a certain field as a result of a database query and/or a join between tables, the result is normally a NULL value.

The Qlik Sense logic treats the following as real NULL values:

NULL values returned from an ODBC connection
NULL values created as a result of a forced concatenation of tables in the data load script
NULL values created as a result of a join made in the data load script
NULL values created as a result of the generation of field value combinations to be displayed in a table

It is generally impossible to use these NULL values for associations and selections, except when the NullAsValue statement is being employed.

Text files per definition cannot contain NULL values.

Learn more

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!