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 QlikView 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 load script

  • NULL values created as a result of a join made in the load script

  • NULL values created as a result of the generation of field value combinations to be displayed in a table

Note: 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.

See also: