topic Re: How can take only one value from multiple values with in one cell in QlikView https://community.qlik.com/t5/QlikView/How-can-take-only-one-value-from-multiple-values-with-in-one/m-p/10048#M1551 <HTML><HEAD></HEAD><BODY><P>Thanks for your great help Jaume,</P></BODY></HTML> Thu, 10 May 2018 16:01:02 GMT rkpatelqlikview 2018-05-10T16:01:02Z How can take only one value from multiple values with in one cell https://community.qlik.com/t5/QlikView/How-can-take-only-one-value-from-multiple-values-with-in-one/m-p/10046#M1549 <HTML><HEAD></HEAD><BODY><P>Hi Qlik,</P><P></P><P>Anyone please help on this.</P><P>There is a multiple values in one cell, Here i need to consider only first one. Please find the excel like Final Column.</P></BODY></HTML> Wed, 09 May 2018 15:02:20 GMT https://community.qlik.com/t5/QlikView/How-can-take-only-one-value-from-multiple-values-with-in-one/m-p/10046#M1549 rkpatelqlikview 2018-05-09T15:02:20Z Re: How can take only one value from multiple values with in one cell https://community.qlik.com/t5/QlikView/How-can-take-only-one-value-from-multiple-values-with-in-one/m-p/10047#M1550 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P>Table:</P><P>LOAD Store, </P><P>&nbsp;&nbsp;&nbsp;&nbsp; codes,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; trim(SubField(codes,',',1)) as Final</P><P>FROM</P><P>[Final.xlsx]</P><P>(ooxml, embedded labels, table is Sheet1);</P></BODY></HTML> Wed, 09 May 2018 15:10:19 GMT https://community.qlik.com/t5/QlikView/How-can-take-only-one-value-from-multiple-values-with-in-one/m-p/10047#M1550 jaumecf23 2018-05-09T15:10:19Z Re: How can take only one value from multiple values with in one cell https://community.qlik.com/t5/QlikView/How-can-take-only-one-value-from-multiple-values-with-in-one/m-p/10048#M1551 <HTML><HEAD></HEAD><BODY><P>Thanks for your great help Jaume,</P></BODY></HTML> Thu, 10 May 2018 16:01:02 GMT https://community.qlik.com/t5/QlikView/How-can-take-only-one-value-from-multiple-values-with-in-one/m-p/10048#M1551 rkpatelqlikview 2018-05-10T16:01:02Z