Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
happyjoshua777
Creator
Creator

question about QlikView CookBook's Using RangeSum to calculate a rolling total in a multidimension table

Hello,

on p. 121 of QlikView for Devs Cookbook we have the following:

" Load the following script:
LOAD * INLINE [
Country, City, Sales, Orders
USA, San Diego, 24567, 546
USA, Dallas, 54962, 345
USA, New York, 67013, 678
USA, Boston, 45824, 365
UK, London, 64002, 743
UK, Birmingham, 44291, 572
UK, Manchester, 40320, 534
Germany, Berlin, 52912, 643
Germany, Frankfurt, 61832, 678
Germany, Munich, 35812, 325
Japan, Tokyo, 42137, 562
Japan, Yokohama, 55832, 753
Japan, 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

thanks

5 Replies
happyjoshua777
Creator
Creator
Author

pivot_table.png

attached pivot_table.png

Anil_Babu_Samineni

I haven't gone thru page no in Cookbook. But, Looks like Rob may forget to add Year field records missed in Inline Memory.

rwunderlich

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
happyjoshua777
Creator
Creator
Author

that was a part of my original post, specifically: '...how does one re-structure the INLINE LOAD to produce the Pivot Table...?'




ta

jonathandienst
Partner - Champion III
Partner - Champion III

Like this:

LOAD * INLINE [

Year, Country, City, Sales, Orders

2017, USA, San Diego, 24567, 546

2016, USA, Dallas, 54962, 345

...

];

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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)

-Rob

http://masterssummit.com

http://qlikviewcookbook.com