topic crosstable issue in QlikView https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/191914#M53818 <HTML><HEAD></HEAD><BODY><P>Hi Heather,</P><P>I'm guessing that you are on an old release of QV 8.5 as this sounds exactly like a bug, 22138, that was around up until 8.50.6299 but was fixed and it's working fine in the latest release, SR6, 8.50.6326. Please upgrade and give it a go.</P></BODY></HTML> Fri, 18 Dec 2009 11:03:12 GMT Anonymous 2009-12-18T11:03:12Z crosstable issue https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/191913#M53817 <HTML><HEAD></HEAD><BODY><P>I am trying to upload an excel file as a cross tab...using the following code:</P><P>CROSSTABLE([Product Category], [Goal Dollars], 2)<BR />LOAD * FROM Datasources\others\NetSalesGoals2010.xls (biff, embedded labels, table is [vLOOKUP $$], filters(<BR />Remove(Col, Pos(Top, 5)),<BR />Remove(Col, Pos(Top, 4)),<BR />Remove(Col, Pos(Top, 3))<BR />));</P><P>My excel file has a date, customer, and then products going across the top with $ going down the columns. The problem I am running into is it appears it is only loading the first row of data. So it loads productA, productB, productC, productD...only once each rather than once for each customer in the spreadsheet. Am I missing a step?</P></BODY></HTML> Fri, 18 Dec 2009 04:28:54 GMT https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/191913#M53817 2009-12-18T04:28:54Z crosstable issue https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/191914#M53818 <HTML><HEAD></HEAD><BODY><P>Hi Heather,</P><P>I'm guessing that you are on an old release of QV 8.5 as this sounds exactly like a bug, 22138, that was around up until 8.50.6299 but was fixed and it's working fine in the latest release, SR6, 8.50.6326. Please upgrade and give it a go.</P></BODY></HTML> Fri, 18 Dec 2009 11:03:12 GMT https://community.qlik.com/t5/QlikView/crosstable-issue/m-p/191914#M53818 Anonymous 2009-12-18T11:03:12Z