topic Structure Data within excel file in QlikView https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099127#M894503 <HTML><HEAD></HEAD><BODY><P>Good day</P><P></P><P>I am struggling to structure the attached file within qlikview. I have been trying to create a cross table but with no luck.&nbsp; Can someone please help?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Structure Data within excel file https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099127#M894503 <HTML><HEAD></HEAD><BODY><P>Good day</P><P></P><P>I am struggling to structure the attached file within qlikview. I have been trying to create a cross table but with no luck.&nbsp; Can someone please help?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099127#M894503 2020-11-25T16:16:04Z Re: Structure Data within excel file https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099128#M894504 <HTML><HEAD></HEAD><BODY><P>use pivot table for this. add dimension in below order</P><P>Customer, Market Sub Segment, year, month</P><P>then add all other expression. then try to drag year above all expr to create cross table then drag month under year. you will get your required crosstable.</P></BODY></HTML> Mon, 01 Aug 2016 09:58:17 GMT https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099128#M894504 2016-08-01T09:58:17Z Re: Structure Data within excel file https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099129#M894505 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Below document may help you regarding same.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Mon, 01 Aug 2016 10:00:55 GMT https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099129#M894505 ashfaq_haseeb 2016-08-01T10:00:55Z Re: Structure Data within excel file https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099130#M894506 <HTML><HEAD></HEAD><BODY><P>Is's in Qlikview / Qlik sense</P></BODY></HTML> Mon, 01 Aug 2016 10:15:04 GMT https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099130#M894506 Anil_Babu_Samineni 2016-08-01T10:15:04Z Re: Structure Data within excel file https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099131#M894507 <HTML><HEAD></HEAD><BODY><P>Qlikview</P></BODY></HTML> Tue, 02 Aug 2016 05:36:35 GMT https://community.qlik.com/t5/QlikView/Structure-Data-within-excel-file/m-p/1099131#M894507 2016-08-02T05:36:35Z