Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Create straight table that only shows the INTERSECTION of selections

I have sales groups with some exclusive and some overlapping clients. How do I create a STRAIGHT TABLE that will only show the INTERSECTING clients with additional selections. The end result will be that if I click on sales group A, it will list all of A's clients, then if I click on sales group B, it will DECREASE the number of clients shown, presenting only the overlapping clients of both sales groups.

I'm pretty sure it involves set analysis using the '*' intersecting syntax but how exactly is this done?

Thanks in advance.

1 Reply
mov
Esteemed Contributor III

Create straight table that only shows the INTERSECTION of selections

Take a look at 'AND' option in list box - it is explained in Help.