Skip to main content Skip to complementary content

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

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.

Learn more


Did this page help you?

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: