# Value handling variables

This section describes variables that are used for handling NULL and other values.

Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/value-handling-variables.htm)

#### NullDisplay

The defined symbol will substitute all NULL values from ODBC, and connectors, on the lowest level of data. This is a user-defined variable.

[**NullDisplay**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullDisplay.htm)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/value-handling-variables.htm)

#### NullInterpret

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

[**NullInterpret**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullInterpret.htm)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/value-handling-variables.htm)

#### NullValue

If the NullAsValue statement is used, the defined symbol will substitute all NULL values in the NullAsValue specified fields with the specified string.

[**NullValue**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/NullValue.htm)

[](https://help.qlik.com/en-US/qlikview/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/value-handling-variables.htm)

#### OtherSymbol

Defines a symbol to be treated as 'all other values' before a LOAD/SELECT statement. This is a user-defined variable.

[**OtherSymbol**](https://help.qlik.com/en-US/qlikview/September2026/Subsystems/Client/Content/QV_QlikView/Scripting/ValueHandlingVariables/OtherSymbol.htm)