topic Re: Separate values in a column in QlikView https://community.qlik.com/t5/QlikView/Separate-values-in-a-column/m-p/66665#M788201 <HTML><HEAD></HEAD><BODY><P>Hi Ankusha,</P><P></P><P>You will get data from subfield function.</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">SubField(FieldName, ',') as FieldName</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Thanks,</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Arvind Patil<BR /></STRONG></P></BODY></HTML> Wed, 07 Feb 2018 13:00:53 GMT arvind_patil 2018-02-07T13:00:53Z Separate values in a column https://community.qlik.com/t5/QlikView/Separate-values-in-a-column/m-p/66663#M788199 <HTML><HEAD></HEAD><BODY><P><IMG alt="delim.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/192713_delim.png" style="font-size: 13.3333px; height: 21px; width: 620px;" /></P><P>30232530,74121110 is the value I have in a column. i want these values separately in two different rows. can anyone please give me query to separate these values?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Separate-values-in-a-column/m-p/66663#M788199 d_ankusha 2020-11-25T16:16:04Z Re: Separate values in a column https://community.qlik.com/t5/QlikView/Separate-values-in-a-column/m-p/66664#M788200 <HTML><HEAD></HEAD><BODY><P>May be using SubField() function</P><P><STRONG>SubField(FieldName, ',') as FieldName</STRONG></P></BODY></HTML> Wed, 07 Feb 2018 12:56:44 GMT https://community.qlik.com/t5/QlikView/Separate-values-in-a-column/m-p/66664#M788200 sunny_talwar 2018-02-07T12:56:44Z Re: Separate values in a column https://community.qlik.com/t5/QlikView/Separate-values-in-a-column/m-p/66665#M788201 <HTML><HEAD></HEAD><BODY><P>Hi Ankusha,</P><P></P><P>You will get data from subfield function.</P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">SubField(FieldName, ',') as FieldName</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;"><BR /></STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Thanks,</STRONG></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #000000;">Arvind Patil<BR /></STRONG></P></BODY></HTML> Wed, 07 Feb 2018 13:00:53 GMT https://community.qlik.com/t5/QlikView/Separate-values-in-a-column/m-p/66665#M788201 arvind_patil 2018-02-07T13:00:53Z