Skip to main content


The defined symbol will be interpreted as NULL when it occurs in a text file, Excel file or an inline statement. This is a user-defined variable.




set NullInterpret=' ';

set NullInterpret =;

will not return NULL values for empty cells in Excel, but it will for a CSV text file.

set NullInterpret ='';

will return NULL values for empty cells in Excel.

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: