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:

 

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?