topic ListBox Show Nulls in QlikView https://community.qlik.com/t5/QlikView/ListBox-Show-Nulls/m-p/527808#M197242 <HTML><HEAD></HEAD><BODY><P>I have a scenario in which I'm populating a ListBox from possible values that I'm pulling from a Database.&nbsp; 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.&nbsp; How do I make the ListBox show the NULL or '-' as a value the user can select?&nbsp; Basically I don't want the ListBox to automatically suppress the NULL value.</P></BODY></HTML> Tue, 08 Oct 2013 12:41:49 GMT 2013-10-08T12:41:49Z ListBox Show Nulls https://community.qlik.com/t5/QlikView/ListBox-Show-Nulls/m-p/527808#M197242 <HTML><HEAD></HEAD><BODY><P>I have a scenario in which I'm populating a ListBox from possible values that I'm pulling from a Database.&nbsp; 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.&nbsp; How do I make the ListBox show the NULL or '-' as a value the user can select?&nbsp; Basically I don't want the ListBox to automatically suppress the NULL value.</P></BODY></HTML> Tue, 08 Oct 2013 12:41:49 GMT https://community.qlik.com/t5/QlikView/ListBox-Show-Nulls/m-p/527808#M197242 2013-10-08T12:41:49Z Re: ListBox Show Nulls https://community.qlik.com/t5/QlikView/ListBox-Show-Nulls/m-p/527809#M197243 <HTML><HEAD></HEAD><BODY><P>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: <A href="https://community.qlik.com/docs/DOC-3155">NULL handling in QlikView</A></P></BODY></HTML> Tue, 08 Oct 2013 12:42:42 GMT https://community.qlik.com/t5/QlikView/ListBox-Show-Nulls/m-p/527809#M197243 Gysbert_Wassenaar 2013-10-08T12:42:42Z Re: ListBox Show Nulls https://community.qlik.com/t5/QlikView/ListBox-Show-Nulls/m-p/527810#M197244 <HTML><HEAD></HEAD><BODY><P>I was hoping to avoid using multiple DECODE statements in my script, but it seems I'll have to.&nbsp; Thanks for the quick reply!</P></BODY></HTML> Tue, 08 Oct 2013 12:57:37 GMT https://community.qlik.com/t5/QlikView/ListBox-Show-Nulls/m-p/527810#M197244 2013-10-08T12:57:37Z