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
Information noteIt 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.
