Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
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...