Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Show the change in records between 2 sets of data

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

PerformerShowWeek
The PebbleCooked17
Double HCooked17
Rock Hot Jane AustenCooked17
Andy NortonCooked17
Broccoli LeicesterCooked17
MiddleCooked17
MuslimCooked17

PerformerShowWeek
The PebbleTouchUp17
Double HTouchUp17
Rock Hot Jane AustenTouchUp17
Andy NortonTouchUp17
The OvergiverTouchUp17
BainTouchUp17
Burt ApexTouchUp17

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.

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

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

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

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

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

Not applicable

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

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


( ͡° ͜ʖ ͡°)