topic Re: How to remove null and special character in list box in QlikView https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408761#M512888 <HTML><HEAD></HEAD><BODY><P>Although a better option would be to derive a clean name field in the load:</P><P></P><P>LOAD ....</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Client name] as <SPAN style="font-size: 13.3333px;">[Client name RAW],</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">KeepChar([Client name], 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')</SPAN> as <SPAN style="font-size: 13.3333px;">[Client name]</SPAN>,</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; ....</SPAN></P></BODY></HTML> Fri, 15 Dec 2017 07:57:47 GMT jonathandienst 2017-12-15T07:57:47Z How to remove null and special character in list box https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408758#M512885 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>My source like below</P><P></P><P>Client name</P><P>(Null data)</P><P>[Raju,"ramu"]</P><P>[Ravi,/u206] </P><P></P><P>Excapted o/p is</P><P>Client name</P><P>NA</P><P>Raju</P><P>Ramu</P><P>Ravi</P></BODY></HTML> Fri, 15 Dec 2017 07:11:27 GMT https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408758#M512885 Anonymous 2017-12-15T07:11:27Z Re: How to remove null and special character in list box https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408759#M512886 <HTML><HEAD></HEAD><BODY><P>You can use the expression in the list box:</P><P></P><P>=KeepChar([Client name], 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')</P></BODY></HTML> Fri, 15 Dec 2017 07:56:04 GMT https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408759#M512886 jonathandienst 2017-12-15T07:56:04Z Re: How to remove null and special character in list box https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408760#M512887 <HTML><HEAD></HEAD><BODY><P>MAY BE THIS</P><P>TEXT(IF(SUBSTRINGCOUNT(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Client name,','</SPAN>)=1,SUBFIELD(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Client name,','</SPAN>),'NA'))</P></BODY></HTML> Fri, 15 Dec 2017 07:56:34 GMT https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408760#M512887 surendraj 2017-12-15T07:56:34Z Re: How to remove null and special character in list box https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408761#M512888 <HTML><HEAD></HEAD><BODY><P>Although a better option would be to derive a clean name field in the load:</P><P></P><P>LOAD ....</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Client name] as <SPAN style="font-size: 13.3333px;">[Client name RAW],</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">KeepChar([Client name], 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')</SPAN> as <SPAN style="font-size: 13.3333px;">[Client name]</SPAN>,</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp; ....</SPAN></P></BODY></HTML> Fri, 15 Dec 2017 07:57:47 GMT https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408761#M512888 jonathandienst 2017-12-15T07:57:47Z Re: How to remove null and special character in list box https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408762#M512889 <HTML><HEAD></HEAD><BODY><P>PFA</P><P><IMG alt="Capture.JPG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/187085_Capture.JPG" style="height: 184px; width: 620px;" /></P><P><IMG alt="Capture2.JPG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/187086_Capture2.JPG" style="height: auto;" /></P></BODY></HTML> Fri, 15 Dec 2017 08:01:08 GMT https://community.qlik.com/t5/QlikView/How-to-remove-null-and-special-character-in-list-box/m-p/1408762#M512889 tresB 2017-12-15T08:01:08Z