topic Re: Seperating list values from a string in QlikView https://community.qlik.com/t5/QlikView/Seperating-list-values-from-a-string/m-p/443119#M165151 <HTML><HEAD></HEAD><BODY><P>Use the subfield function</P><P></P><P>load *, subfield(list,',') as listitem from ...etc</P><P></P><P>You may want to use trim too to get rid of extra spaces: trim(subfield(list,','))</P></BODY></HTML> Sat, 17 Nov 2012 15:07:22 GMT Gysbert_Wassenaar 2012-11-17T15:07:22Z Seperating list values from a string https://community.qlik.com/t5/QlikView/Seperating-list-values-from-a-string/m-p/443118#M165150 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have column in an excel, with values like </P><P></P><P>list value5</P><P>list value1, list value2, list value3</P><P></P><P>Is there any way using list box expression, the second line item above can be shown as sepererate list values in a list box?</P><P></P><P>as:</P><P></P><P><STRONG>List</STRONG></P><P>list value5</P><P>list value1</P><P>list value2</P><P>list value3</P><P></P><P>Thanks,</P><P></P><P>Abey</P></BODY></HTML> Sat, 17 Nov 2012 14:44:17 GMT https://community.qlik.com/t5/QlikView/Seperating-list-values-from-a-string/m-p/443118#M165150 abeyphilip 2012-11-17T14:44:17Z Re: Seperating list values from a string https://community.qlik.com/t5/QlikView/Seperating-list-values-from-a-string/m-p/443119#M165151 <HTML><HEAD></HEAD><BODY><P>Use the subfield function</P><P></P><P>load *, subfield(list,',') as listitem from ...etc</P><P></P><P>You may want to use trim too to get rid of extra spaces: trim(subfield(list,','))</P></BODY></HTML> Sat, 17 Nov 2012 15:07:22 GMT https://community.qlik.com/t5/QlikView/Seperating-list-values-from-a-string/m-p/443119#M165151 Gysbert_Wassenaar 2012-11-17T15:07:22Z Re: Seperating list values from a string https://community.qlik.com/t5/QlikView/Seperating-list-values-from-a-string/m-p/443120#M165152 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert,</P><P></P><P>Perfect. Thanks a lot!!!</P></BODY></HTML> Sat, 17 Nov 2012 15:16:58 GMT https://community.qlik.com/t5/QlikView/Seperating-list-values-from-a-string/m-p/443120#M165152 abeyphilip 2012-11-17T15:16:58Z