topic Re: Making a selection from variable using subfield in QlikView https://community.qlik.com/t5/QlikView/Making-a-selection-from-variable-using-subfield/m-p/950335#M326893 <HTML><HEAD></HEAD><BODY><P>Sorry everyone - just figured it out.&nbsp; The use of purgechar</P><P></P><P>purgechar(s<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ubfield(variable name,',',variable number),chr(39))</SPAN></P></BODY></HTML> Sat, 10 Oct 2015 02:53:10 GMT Anonymous 2015-10-10T02:53:10Z Making a selection from variable using subfield https://community.qlik.com/t5/QlikView/Making-a-selection-from-variable-using-subfield/m-p/950334#M326892 <HTML><HEAD></HEAD><BODY><P>I have a variable in which I would like to make a selection using subfield function.&nbsp; I'm using the action Select in Field and in the search string I use subfield(variable name,',',variable number).</P><P></P><P>My variable is a list of field names within quotes.&nbsp; Example: 'name1','name2','name3', etc</P><P></P><P>The quotes create the issue.&nbsp; I can get the right name with the subfield but theSelect in Field wont work. Is there another function that would strip away the quotes? </P></BODY></HTML> Sat, 10 Oct 2015 02:43:02 GMT https://community.qlik.com/t5/QlikView/Making-a-selection-from-variable-using-subfield/m-p/950334#M326892 Anonymous 2015-10-10T02:43:02Z Re: Making a selection from variable using subfield https://community.qlik.com/t5/QlikView/Making-a-selection-from-variable-using-subfield/m-p/950335#M326893 <HTML><HEAD></HEAD><BODY><P>Sorry everyone - just figured it out.&nbsp; The use of purgechar</P><P></P><P>purgechar(s<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ubfield(variable name,',',variable number),chr(39))</SPAN></P></BODY></HTML> Sat, 10 Oct 2015 02:53:10 GMT https://community.qlik.com/t5/QlikView/Making-a-selection-from-variable-using-subfield/m-p/950335#M326893 Anonymous 2015-10-10T02:53:10Z