Discussion Board for collaboration related to QlikView App Development.
on p. 121 of QlikView for Devs Cookbook we have the following:
" Load the following script:LOAD * INLINE [Country, City, Sales, OrdersUSA, San Diego, 24567, 546USA, Dallas, 54962, 345USA, New York, 67013, 678USA, Boston, 45824, 365UK, London, 64002, 743UK, Birmingham, 44291, 572UK, Manchester, 40320, 534Germany, Berlin, 52912, 643Germany, Frankfurt, 61832, 678Germany, Munich, 35812, 325Japan, Tokyo, 42137, 562Japan, Yokohama, 55832, 753Japan, Osaka, 37643, 418];
Yet the first Step is 'Create a new pivot table with Year and Country as dimensions. '
However, there is no 'Year' dimension in the INLINE LOAD (see above).
Am I missing something?
If is an error in the book, how does one re-structure the INLINE LOAD to produce the Pivot Table as per p. 122 of this textbook?
Refer to pivot_table.png which I attached to this discussion
I haven't gone thru page no in Cookbook. But, Looks like Rob may forget to add Year field records missed in Inline Memory.
that was a part of my original post, specifically: '...how does one re-structure the INLINE LOAD to produce the Pivot Table...?'
LOAD * INLINE [
Year, Country, City, Sales, Orders
2017, USA, San Diego, 24567, 546
2016, USA, Dallas, 54962, 345
This error is reported in the Errata page for the book: https://www.packtpub.com/books/content/support/12458
The suggested workaround is to use the load on page 123.
(BTW, that's stephen-x.redmond's book. I'm the publisher of the QlikCookbook.com website)