topic Trying to add subfields in QlikView https://community.qlik.com/t5/QlikView/Trying-to-add-subfields/m-p/602788#M222764 <HTML><HEAD></HEAD><BODY><P>I have attached a excel file. I want 5 subfields under a field. Please suggest what kind of approach should be applied.</P></BODY></HTML> Wed, 05 Mar 2014 12:09:57 GMT 2014-03-05T12:09:57Z Trying to add subfields https://community.qlik.com/t5/QlikView/Trying-to-add-subfields/m-p/602788#M222764 <HTML><HEAD></HEAD><BODY><P>I have attached a excel file. I want 5 subfields under a field. Please suggest what kind of approach should be applied.</P></BODY></HTML> Wed, 05 Mar 2014 12:09:57 GMT https://community.qlik.com/t5/QlikView/Trying-to-add-subfields/m-p/602788#M222764 2014-03-05T12:09:57Z Re: Trying to add subfields https://community.qlik.com/t5/QlikView/Trying-to-add-subfields/m-p/602789#M222765 <HTML><HEAD></HEAD><BODY><P>Look at CrossTable in the help file. You will have to indicate how many qualifier fields you have and then it will transform your load so all subsequent fields get captured as 1 field</P><P></P><P>example:</P><P></P><P>Sales:</P><P>LOAD * INLINE [</P><P>Product,Jan, Feb, Mar, Apr</P><P>a,1,2,3,4</P><P>b,2,3,4,5</P><P>c,3,4,5,6</P><P>d,4,5,6,7];</P><P></P><P>DataFinal:</P><P>Crosstable (Month,Sales,1)</P><P>LOAD *</P><P>RESIDENT Sales;</P><P></P><P></P><P>Cheers,</P><P>Byron</P></BODY></HTML> Wed, 05 Mar 2014 12:59:25 GMT https://community.qlik.com/t5/QlikView/Trying-to-add-subfields/m-p/602789#M222765 2014-03-05T12:59:25Z