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