How to display NULL values as 'NULL' instead of '-'

[#1]

Hi all. I've got some charts with null values in them. By default, QlikView displays null values as '-'. This doesn't make any sense to my users, so I want it to say 'NULL' instead. I tried a number of things, SET NullValue = 'NULL'; or SET NullDisplay = 'NULL'; but neither worked. Does anyone know how to do this? Thanks!

Eric

[whiteline]

EndDate = NULL

The right way to test if the value is null is function ISNULL.

Use  WHERE  IsNull(EndDate) and StartDate <= Today();