Show the change in records between 2 sets of data

Wed, 04 Feb 2015 14:32:29 GMT

I have a table which reads data from two different sources, containing details of performers appearing on a show:

Performer	Show	Week
The Pebble	Cooked	17
Double H	Cooked	17
Rock Hot Jane Austen	Cooked	17
Andy Norton	Cooked	17
Broccoli Leicester	Cooked	17
Middle	Cooked	17
Muslim	Cooked	17

Performer	Show	Week
The Pebble	TouchUp	17
Double H	TouchUp	17
Rock Hot Jane Austen	TouchUp	17
Andy Norton	TouchUp	17
The Overgiver	TouchUp	17
Bain	TouchUp	17
Burt Apex	TouchUp	17

Table1:

=sum({<Show = {'Cooked'}, Week = {'$(vWeek)'}, City = {'$(vCity)'}>}RecCounter)

Table2:

=sum({<Show = {'TouchUp'}, Week = {'$(vWeek)'}, City = {'$(vCity)'}>}RecCounter)

From this, I'm looking to produce two further tables showing performers which only appear in ONE of the two shows in one week; i.e. one table showing just the orange rows, and the other table showing just the light blue rows. Any ideas on what set expressions I should use for these two tables? I've tried using symmetric difference set operators but had no luck so far. Thanks.

Re: Show the change in records between 2 sets of data

Gysbert_Wassenaar — Wed, 04 Feb 2015 14:45:51 GMT

See attached qvw.

Re: Show the change in records between 2 sets of data

Thu, 05 Feb 2015 10:24:14 GMT

Thanks, that works like a dream. Who would have thought an E could be so helpful?

( ͡° ͜ʖ ͡°)

topic Re: Show the change in records between 2 sets of data in QlikView

Show the change in records between 2 sets of data

Re: Show the change in records between 2 sets of data

Re: Show the change in records between 2 sets of data