topic Loading 3 dimensional excel sheet in QlikView https://community.qlik.com/t5/QlikView/Loading-3-dimensional-excel-sheet/m-p/276349#M709455 <HTML><HEAD></HEAD><BODY><P>I have a 3 dimensional excel sheet and need to load it in Qlick View (Account, Amount, Date) ....</P><P></P><P>I have attached a sample of the excel sheet .... any help </P><P></P><P>Regards, </P></BODY></HTML> Wed, 13 Jul 2011 06:40:13 GMT 2011-07-13T06:40:13Z Loading 3 dimensional excel sheet https://community.qlik.com/t5/QlikView/Loading-3-dimensional-excel-sheet/m-p/276349#M709455 <HTML><HEAD></HEAD><BODY><P>I have a 3 dimensional excel sheet and need to load it in Qlick View (Account, Amount, Date) ....</P><P></P><P>I have attached a sample of the excel sheet .... any help </P><P></P><P>Regards, </P></BODY></HTML> Wed, 13 Jul 2011 06:40:13 GMT https://community.qlik.com/t5/QlikView/Loading-3-dimensional-excel-sheet/m-p/276349#M709455 2011-07-13T06:40:13Z Loading 3 dimensional excel sheet https://community.qlik.com/t5/QlikView/Loading-3-dimensional-excel-sheet/m-p/276350#M709456 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>split the excel into&nbsp; two excel files</P><P></P><P>one is for Debit and another is for Credit.</P><P></P><P>do the crosstable function,</P><P></P><P>Load separately then join both the tables.</P></BODY></HTML> Wed, 13 Jul 2011 09:57:08 GMT https://community.qlik.com/t5/QlikView/Loading-3-dimensional-excel-sheet/m-p/276350#M709456 2011-07-13T09:57:08Z