topic Issues loading Pivot from Excel to Qlikview in QlikView https://community.qlik.com/t5/QlikView/Issues-loading-Pivot-from-Excel-to-Qlikview/m-p/206970#M62887 <HTML><HEAD></HEAD><BODY><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3681.Sourcetest.xlsx:550:0]</P><P>Dear Ladies and Gentlemen,</P><P>I'm struggeling with the load of an Privot Table from Excel.</P><P>It looks like this:</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3508_sourceID:3508" /></P><P>It outcome should be to Table structure like this importet in Qlikview:</P><P>Category | Product | YearMonth | Quantity | Amount | Avg Price |</P><P></P><P>I've tried with crosstable functions but nothing gave the format needed.</P><P>Thanks for your help!</P></BODY></HTML> Wed, 09 Feb 2011 08:58:53 GMT 2011-02-09T08:58:53Z Issues loading Pivot from Excel to Qlikview https://community.qlik.com/t5/QlikView/Issues-loading-Pivot-from-Excel-to-Qlikview/m-p/206970#M62887 <HTML><HEAD></HEAD><BODY><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3681.Sourcetest.xlsx:550:0]</P><P>Dear Ladies and Gentlemen,</P><P>I'm struggeling with the load of an Privot Table from Excel.</P><P>It looks like this:</P><P></P><P><IMG alt="error loading image" class="jive-image error-loading-image" src="https://community.qlik.com/legacyfs/online/-3508_sourceID:3508" /></P><P>It outcome should be to Table structure like this importet in Qlikview:</P><P>Category | Product | YearMonth | Quantity | Amount | Avg Price |</P><P></P><P>I've tried with crosstable functions but nothing gave the format needed.</P><P>Thanks for your help!</P></BODY></HTML> Wed, 09 Feb 2011 08:58:53 GMT https://community.qlik.com/t5/QlikView/Issues-loading-Pivot-from-Excel-to-Qlikview/m-p/206970#M62887 2011-02-09T08:58:53Z