Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Null value in Listbox

Hi

I am new to Qlikview. Could anyone please let me know how to populate missing or null values in List box( syntax would be of great help)

2 Replies
sunny_talwar

May be add this to to the script:

NULLASVALUE Field1;

SET NullValue = 'NULL';

LOAD Field1,

          OtherFields

From .....;

Now Field1 will show NULL in place of actually nulls in field1

Look here also:

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptRegularStatement...