How to avoid adding null values

[#1]

Hi,

I was wondering if it's possible to avoid adding null values '-' in the tables? I'am having problems displaying values on text object lately because the total sum on my table is not equal on the text object and I think it's because of the null values on the DB.

hope you help me on my problem, thanks

[Ralf-Narfeldt · Accepted solution]

Are you loading the DB with ODBC?

This part from the QlikView help may assist you:

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. By using the syntax:

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:

SET NULLDISPLAY=;

Note!
The 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=";

Note!
Here '' is actually two single quotation marks without anything in between.