topic Null value in Listbox in QlikView https://community.qlik.com/t5/QlikView/Null-value-in-Listbox/m-p/1135840#M895156 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z Null value in Listbox https://community.qlik.com/t5/QlikView/Null-value-in-Listbox/m-p/1135840#M895156 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>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)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Null-value-in-Listbox/m-p/1135840#M895156 Anonymous 2020-11-25T16:16:04Z Re: Null value in Listbox https://community.qlik.com/t5/QlikView/Null-value-in-Listbox/m-p/1135841#M895157 <HTML><HEAD></HEAD><BODY><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/30/null-the-invisible-nothing" title="https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/30/null-the-invisible-nothing">https://community.qlik.com/blogs/qlikviewdesignblog/2013/04/30/null-the-invisible-nothing</A></P></BODY></HTML> Thu, 04 Aug 2016 21:03:21 GMT https://community.qlik.com/t5/QlikView/Null-value-in-Listbox/m-p/1135841#M895157 Clever_Anjos 2016-08-04T21:03:21Z Re: Null value in Listbox https://community.qlik.com/t5/QlikView/Null-value-in-Listbox/m-p/1135842#M895158 <HTML><HEAD></HEAD><BODY><P>May be add this to to the script:</P><P></P><P>NULLASVALUE Field1;</P><P>SET NullValue = 'NULL';</P><P></P><P>LOAD Field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OtherFields</P><P>From .....;</P><P></P><P>Now Field1 will show NULL in place of actually nulls in field1</P><P></P><P>Look here also:</P><P><A href="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptRegularStatements/NullAsValue.htm" title="https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptRegularStatements/NullAsValue.htm">https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Scripting/ScriptRegularStatements/NullAsValue.htm</A></P></BODY></HTML> Thu, 04 Aug 2016 21:04:21 GMT https://community.qlik.com/t5/QlikView/Null-value-in-Listbox/m-p/1135842#M895158 sunny_talwar 2016-08-04T21:04:21Z