Multiple Selection in QlikView

[#1]

Hi, all.

I want to select two columns' records at once. But I don't know how to achieve that.

For example, I have two columns, named 'Seller' and 'Buyer'. And I got some records like below:

Seller	Buyer
A	B
A	C
B	A
C	D
D	E
E	A
D	B

Now, I want to have ONE list box or something, but just one, that can make me to select ABCDE. Then once I select A (or BCDE), the records that contain A (or BCDE) will be filterd and displayed, no matter it is in Seller or Buyer. The results will be like:

Seller	Buyer
A	B
A	C
B	A
E	A

Cause every list box needs a field to create, once I choose Seller as the field, it only shows Seller's records.

So, I want to choose one and select both. How can I make that? Hope I express myself clearly.

Many thanks!

[tresesco]

Rui Bao wrote:

... I don't think this selection can be done simultaneously..

And you want this to make possibly? I am not sure, even after this long I could really understand what you want.

[#3]

I just want the result I put in the question description.

Anyway, still many thanks to your help and patience.

[tresesco]

I guess your requirement is defying qlik association logic. Anyway, best of luck!