Skip to main content

Associating/selecting NULL values from ODBC

It is possible to associate and/or select NULL values from an ODBC data source. For this purpose a script variable has been defined. The following syntax can be used:

SET NULLDISPLAY=<sym>;

The symbol <sym> will substitute all NULL values from the ODBC data source on the lowest level of data input. <sym> may be any string.

In order to reset this functionality to the default interpretation, use the following syntax:

SET NULLDISPLAY=;

Information noteThe use of NULLDISPLAY only affects data from an ODBC data source.

If you wish to have the QlikView logic interpret NULL values returned from an ODBC connection as an empty string, add the following to your script before any SELECT statement:

SET NULLDISPLAY=";

Information noteHere '' is actually two single quotation marks without anything in between.

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: ampquestions@qlik.com