Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
I just want the result I put in the question description.
Anyway, still many thanks to your help and patience.
I guess your requirement is defying qlik association logic. Anyway, best of luck!