topic transformation complex excel file in QlikView https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052608#M353162 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>can we do transformation for below complex excel file to normal table&nbsp; in the qvw??</P><P></P><P>please do some need full</P><P></P><P>Thanks</P><P>Devendar</P></BODY></HTML> Fri, 22 Jan 2016 10:08:08 GMT Anonymous 2016-01-22T10:08:08Z transformation complex excel file https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052608#M353162 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>can we do transformation for below complex excel file to normal table&nbsp; in the qvw??</P><P></P><P>please do some need full</P><P></P><P>Thanks</P><P>Devendar</P></BODY></HTML> Fri, 22 Jan 2016 10:08:08 GMT https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052608#M353162 Anonymous 2016-01-22T10:08:08Z Re: transformation complex excel file https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052609#M353163 <HTML><HEAD></HEAD><BODY><P>Check these, helpful for you?</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P><P></P><P><A href="https://community.qlik.com/thread/188258">CrossTable from Excel with Multiple Headers</A></P><P></P><P><A href="https://community.qlik.com/thread/40363">Create table in QV with multiple header rows</A></P></BODY></HTML> Fri, 22 Jan 2016 10:13:34 GMT https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052609#M353163 Anonymous 2016-01-22T10:13:34Z Re: transformation complex excel file https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052610#M353164 <HTML><HEAD></HEAD><BODY><P>Could you post your expected output.!!</P></BODY></HTML> Fri, 22 Jan 2016 10:14:44 GMT https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052610#M353164 tamilarasu 2016-01-22T10:14:44Z Re: transformation complex excel file https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052611#M353165 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>we have 2013, 2012 data in the excel file right, when am taking 2013 and 2012 as filter, under 2013 it should be total sales and e-commerce i.e</P><P></P><P>hope you understand </P></BODY></HTML> Fri, 22 Jan 2016 11:13:03 GMT https://community.qlik.com/t5/QlikView/transformation-complex-excel-file/m-p/1052611#M353165 Anonymous 2016-01-22T11:13:03Z