Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

crosstable issue

I am trying to upload an excel file as a cross tab...using the following code:

CROSSTABLE([Product Category], [Goal Dollars], 2)
LOAD * FROM Datasources\others\NetSalesGoals2010.xls (biff, embedded labels, table is [vLOOKUP $$], filters(
Remove(Col, Pos(Top, 5)),
Remove(Col, Pos(Top, 4)),
Remove(Col, Pos(Top, 3))
));

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?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

Hi Heather,

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.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

Hi Heather,

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.