topic Re: combining the fields in QlikView https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341264#M126087 <HTML><HEAD></HEAD><BODY><P>Hm, sounds like you want to do something like this:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; etc, </P><P><EM>subfield(DS_DELAY_SUB_CODE_1 &amp; ';' &amp; DS_DELAY_SUB_CODE_2 &amp; ';' &amp; DS_DELAY_SUB_CODE_3 &amp; ';' &amp; DS_DELAY_SUB_CODE_4, ';') as DS_DELAY_SUB_CODE</EM></P><P>From EXCELFILE.....</P></BODY></HTML> Tue, 07 Aug 2012 06:58:57 GMT Anonymous 2012-08-07T06:58:57Z combining the fields https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341263#M126086 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>i want to combine 4 columns( F, G, H, I) with 120 lines </P><P>to single 1 column with 480 lines </P><P></P><P>How can i do this </P><P></P><P>Thanks a lot</P></BODY></HTML> Tue, 07 Aug 2012 06:53:00 GMT https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341263#M126086 2012-08-07T06:53:00Z Re: combining the fields https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341264#M126087 <HTML><HEAD></HEAD><BODY><P>Hm, sounds like you want to do something like this:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Field2,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; etc, </P><P><EM>subfield(DS_DELAY_SUB_CODE_1 &amp; ';' &amp; DS_DELAY_SUB_CODE_2 &amp; ';' &amp; DS_DELAY_SUB_CODE_3 &amp; ';' &amp; DS_DELAY_SUB_CODE_4, ';') as DS_DELAY_SUB_CODE</EM></P><P>From EXCELFILE.....</P></BODY></HTML> Tue, 07 Aug 2012 06:58:57 GMT https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341264#M126087 Anonymous 2012-08-07T06:58:57Z Re: combining the fields https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341265#M126088 <HTML><HEAD></HEAD><BODY><P>thank you very much</P></BODY></HTML> Tue, 07 Aug 2012 10:25:47 GMT https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341265#M126088 2012-08-07T10:25:47Z Re: combining the fields https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341266#M126089 <HTML><HEAD></HEAD><BODY><P>can you also help me about this subject i want to have subfileds&nbsp; without '?' marks</P><P>is it possible or is there an easy way</P></BODY></HTML> Tue, 07 Aug 2012 11:49:14 GMT https://community.qlik.com/t5/QlikView/combining-the-fields/m-p/341266#M126089 2012-08-07T11:49:14Z