topic Re: How to filter out hide/remove number values only in List Box in QlikView https://community.qlik.com/t5/QlikView/How-to-filter-out-hide-remove-number-values-only-in-List-Box/m-p/1360759#M833145 <HTML><HEAD></HEAD><BODY><P>what exactly does the data look like!!</P></BODY></HTML> Tue, 13 Jun 2017 11:54:19 GMT vinieme12 2017-06-13T11:54:19Z How to filter out hide/remove number values only in List Box https://community.qlik.com/t5/QlikView/How-to-filter-out-hide-remove-number-values-only-in-List-Box/m-p/1360757#M833143 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>New to Qlikview. I was given a query for taking Excel data and separating out numbers from within the values (e.g., 5G;#1, CAPLAIN;#2, etc.):</P><P></P><P>table1:</P><P>load * from table1;</P><P></P><P>RecordTagsFromTable1:</P><P>load KeyWords, subfield(purgechar(KeyWords, '#'), ';') as RecordTag resident table1;</P><P></P><P>The results produced a list box that separated word values from the number values:</P><P></P><P>List Box:</P><P>5G</P><P>CAPLAN</P><P>AMI</P><P>1</P><P>2</P><P>3</P><P></P><P>Is there a way to remove the numbers and just keep the text values?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-filter-out-hide-remove-number-values-only-in-List-Box/m-p/1360757#M833143 2020-11-25T16:16:04Z Re: How to filter out hide/remove number values only in List Box https://community.qlik.com/t5/QlikView/How-to-filter-out-hide-remove-number-values-only-in-List-Box/m-p/1360758#M833144 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">table1:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">load * from table1;</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">RecordTagsFromTable1:</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">load KeyWords, subfield(KeyWords, <STRONG>';' , 1)</STRONG> as RecordTag resident table1;</P></BODY></HTML> Tue, 13 Jun 2017 11:51:38 GMT https://community.qlik.com/t5/QlikView/How-to-filter-out-hide-remove-number-values-only-in-List-Box/m-p/1360758#M833144 vinieme12 2017-06-13T11:51:38Z Re: How to filter out hide/remove number values only in List Box https://community.qlik.com/t5/QlikView/How-to-filter-out-hide-remove-number-values-only-in-List-Box/m-p/1360759#M833145 <HTML><HEAD></HEAD><BODY><P>what exactly does the data look like!!</P></BODY></HTML> Tue, 13 Jun 2017 11:54:19 GMT https://community.qlik.com/t5/QlikView/How-to-filter-out-hide-remove-number-values-only-in-List-Box/m-p/1360759#M833145 vinieme12 2017-06-13T11:54:19Z