topic Re: Cross table in QlikView https://community.qlik.com/t5/QlikView/Cross-table/m-p/1107708#M897968 <HTML><HEAD></HEAD><BODY><P>Your Expected O/P</P></BODY></HTML> Tue, 02 Aug 2016 07:41:44 GMT Anil_Babu_Samineni 2016-08-02T07:41:44Z Cross table https://community.qlik.com/t5/QlikView/Cross-table/m-p/1107707#M897967 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have problem in loading these excel sheet </P><P>Help me out.</P><P></P><P>PFA</P><P></P><P>Regards,</P><P>Joshua.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Cross-table/m-p/1107707#M897967 ajsjoshua 2020-11-25T16:16:04Z Re: Cross table https://community.qlik.com/t5/QlikView/Cross-table/m-p/1107708#M897968 <HTML><HEAD></HEAD><BODY><P>Your Expected O/P</P></BODY></HTML> Tue, 02 Aug 2016 07:41:44 GMT https://community.qlik.com/t5/QlikView/Cross-table/m-p/1107708#M897968 Anil_Babu_Samineni 2016-08-02T07:41:44Z Re: Cross table https://community.qlik.com/t5/QlikView/Cross-table/m-p/1107709#M897969 <HTML><HEAD></HEAD><BODY><P>Hi Joshua,</P><P></P><P>I think you don't need cross table here. </P><P>I see that the structure is same in every sheet in the excel file, so you need to concatenate them.</P><P>Use the for loop to loop into each sheet and create a date column.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4452">Load Multiple excel sheets using For loop</A></P></BODY></HTML> Tue, 02 Aug 2016 07:52:17 GMT https://community.qlik.com/t5/QlikView/Cross-table/m-p/1107709#M897969 bharath28 2016-08-02T07:52:17Z