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

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

happyjoshua777 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

happyjoshua777 — Mon, 07 Aug 2017 02:57:58 GMT

attached pivot_table.png

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

Anil_Babu_Samineni — Mon, 07 Aug 2017 03:30:44 GMT

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

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

happyjoshua777 — Mon, 07 Aug 2017 04:06:08 GMT

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

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

jonathandienst — Mon, 07 Aug 2017 04:48:20 GMT

Like this:

LOAD * INLINE [

Year, Country, City, Sales, Orders

2017, USA, San Diego, 24567, 546

2016, USA, Dallas, 54962, 345

...

];

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

rwunderlich — Wed, 16 Aug 2017 01:26:34 GMT

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