let Qlikview show you all results where a selected combination of items is selected?

[#1]

Is there an easy way to let Qlikview show you all results where a selected combination of items is selected?

for example there are 2 tables: salesorder and salesorderline (see below) and I want to see in which salesorder the combination of item A and B is sold. In the example below this should result in salesorders 1 and 3 (and not also 4 and 5)

SalesOrder	SalesOrderLine		Item
1	1		A
1	2		B
1	3		C
2	1		A
2	2		D
2	3		E
3	1		A
3	2		B
4	1		X
4	2		Y
4	3		Z
5	1		B
5	2		X

Thanks for helping me!

[#2]

I think you should be able to use Set Analysis and in particular the P() function.

Try:

Sum({<Item=P({<Item={'A'}>*<Item={'B'}>}Item)>} Sales)

I'm not sure what your expressions are, but that worked on some sample data I had.

[johnw]

If you're looking for something more dynamic, look for "and-mode in list boxes" in the help text. See attached example.