ListBox Show Nulls

[#1]

I have a scenario in which I'm populating a ListBox from possible values that I'm pulling from a Database.  NULL is a valid value for the field in my database and I need a way to allow the user to choose NULL as their selected value in the ListBox.  How do I make the ListBox show the NULL or '-' as a value the user can select?  Basically I don't want the ListBox to automatically suppress the NULL value.

[Gysbert_Wassenaar · Accepted solution]

A listbox cannot show nulls. You will have to replace the nulls in the script with real values. Read this document for how to deal with nulls: NULL handling in QlikView

[#3]

I was hoping to avoid using multiple DECODE statements in my script, but it seems I'll have to.  Thanks for the quick reply!