Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Multiple Selection in QlikView

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:

SellerBuyer
AB
AC
BA
CD
DE
EA
DB

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:

SellerBuyer
AB
AC
BA
EA

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!

22 Replies
tresesco
MVP
MVP

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.

Not applicable
Author

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

Anyway, still many thanks to your help and patience.

tresesco
MVP
MVP

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