Skip to main content

NULL - script and chart function

The Null function returns a NULL value.


Null( )

Example: Load script

In this example, an inline table with four rows is loaded, where the first three lines contain either nothing, - or 'NULL' in the Value column. We want to convert these values to true NULL value representations.

The middle preceding LOAD performs the conversion using the Null function.

The first preceding LOAD adds a field checking if the value is NULL, just for illustration purposes in this example.

NullsDetectedAndConverted: LOAD *, If(IsNull(ValueNullConv), 'T', 'F') as IsItNull; LOAD *, If(len(trim(Value))= 0 or Value='NULL' or Value='-', Null(), Value ) as ValueNullConv; LOAD * Inline [ID, Value 0, 1,NULL 2,- 3,Value];

This is the resulting table. In the ValueNullConv column, the NULL values are represented by -.

Example 1
ID Value ValueNullConv


0 - - T
1 NULL - T
2 - - T
3 Value Value F

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: