Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Tags (2)
5 Replies
Highlighted
Creator
Creator

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

pivot_table.png

attached pivot_table.png

Highlighted

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

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

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)
Highlighted
Creator
Creator

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

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




ta

Highlighted

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

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
Highlighted
MVP & Luminary
MVP & Luminary

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

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