topic Re: Break down of data in one row into multiple rows in QlikView https://community.qlik.com/t5/QlikView/Break-down-of-data-in-one-row-into-multiple-rows/m-p/1296034#M404531 <HTML><HEAD></HEAD><BODY><P>Check this link out:</P><P><A href="https://community.qlik.com/docs/DOC-4657">The Secret Life of SubField</A></P><P></P><P>May be like this</P><P></P><P><STRONG>LOAD ID,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubField(Countries, Chr(10)) as Country</STRONG></P><P><STRONG>FROM ....</STRONG></P><P></P><P>or</P><P></P><P style="font-size: 13.3333px;"><STRONG>LOAD ID,</STRONG></P><P style="font-size: 13.3333px;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubField(Countries, Chr(13)) as Country</STRONG></P><P style="font-size: 13.3333px;"><STRONG>FROM ....</STRONG></P></BODY></HTML> Tue, 28 Mar 2017 18:23:34 GMT sunny_talwar 2017-03-28T18:23:34Z Break down of data in one row into multiple rows https://community.qlik.com/t5/QlikView/Break-down-of-data-in-one-row-into-multiple-rows/m-p/1296033#M404530 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to break data from one row and display them as different rows.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/157970_pastedImage_2.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>In the above mentioned examples, for ID - 2, I have 3 countries. Now I want to display each country in each row.</P><P></P><P>I am looking to achieve this:</P><P></P><P><IMG class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/157971_pastedImage_3.png" style="max-height: 900px; max-width: 1200px;" /></P><P></P><P>Can anyone came across this situation?</P><P></P><P>Thanks,</P><P>Varun</P></BODY></HTML> Tue, 28 Mar 2017 17:46:24 GMT https://community.qlik.com/t5/QlikView/Break-down-of-data-in-one-row-into-multiple-rows/m-p/1296033#M404530 varunreddy 2017-03-28T17:46:24Z Re: Break down of data in one row into multiple rows https://community.qlik.com/t5/QlikView/Break-down-of-data-in-one-row-into-multiple-rows/m-p/1296034#M404531 <HTML><HEAD></HEAD><BODY><P>Check this link out:</P><P><A href="https://community.qlik.com/docs/DOC-4657">The Secret Life of SubField</A></P><P></P><P>May be like this</P><P></P><P><STRONG>LOAD ID,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubField(Countries, Chr(10)) as Country</STRONG></P><P><STRONG>FROM ....</STRONG></P><P></P><P>or</P><P></P><P style="font-size: 13.3333px;"><STRONG>LOAD ID,</STRONG></P><P style="font-size: 13.3333px;"><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SubField(Countries, Chr(13)) as Country</STRONG></P><P style="font-size: 13.3333px;"><STRONG>FROM ....</STRONG></P></BODY></HTML> Tue, 28 Mar 2017 18:23:34 GMT https://community.qlik.com/t5/QlikView/Break-down-of-data-in-one-row-into-multiple-rows/m-p/1296034#M404531 sunny_talwar 2017-03-28T18:23:34Z Re: Break down of data in one row into multiple rows https://community.qlik.com/t5/QlikView/Break-down-of-data-in-one-row-into-multiple-rows/m-p/1296035#M404532 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>Thanks for your quick response!</P></BODY></HTML> Tue, 28 Mar 2017 18:26:42 GMT https://community.qlik.com/t5/QlikView/Break-down-of-data-in-one-row-into-multiple-rows/m-p/1296035#M404532 varunreddy 2017-03-28T18:26:42Z