topic Re: Multiple Selection in QlikView in QlikView

Multiple Selection in QlikView

Mon, 31 Jul 2017 02:29:20 GMT

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!

Re: Multiple Selection in QlikView

tresB — Mon, 31 Jul 2017 09:26:48 GMT

In one way, you could create a dummy field with all possible values (from both buyer and seller fields) and setting trigger, like:

Note: You might not see all values from both fields selected unless they all are in possible selection state after one applied selection (that order could be set in trigger order)

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 02:14:29 GMT

Many thanks for your reply and help!!

But what if I have hundreds of records? Then it will be very trouble to enter them all in the inline table.

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 03:57:01 GMT

Hi,

Create a new variable called Buyer|Seller with value like A|B where A in a value of buyer and B is a value of seller.

This will create all list of buyer and seller combination.

If we want to select records containing A, then select A in search box for variable Buyer|Seller and we will get list of all combinations for which either buyer or seller is A.

This could be extended to any number of items.

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 05:36:39 GMT

Hi, thanks to your reply.

But can you go more specific? You mean create a new variable or a new field? And the combination is like just ABCDE or A|B, B|C? I tried but still cannot work.

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 05:46:34 GMT

Hi Rui,

just create a list box with calculated dimension

=Buyer&'|'&Seller and put the name of list box as you please.

now in the list box select A , it will show all options containing A.

That will contain list of all selections for Buyer and Seller combinations in which A is either buyer or seller.

Re: Multiple Selection in QlikView

Sergey_Shuklin — Tue, 01 Aug 2017 05:47:25 GMT

Hello, Rui!

There will be helpful an Alter States and a field dynamicaly combined with both of your fields.

You may find this topic helpful:

Re: Dynamic Update of field depending on Selection

Re: Multiple Selection in QlikView

tresB — Tue, 01 Aug 2017 05:57:24 GMT

You can just get them using simple load like:

Load Distinct

Seller as CommSel

From <>:

Load Distinct

Buyer as CommSel

From <>:

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 06:14:43 GMT

Hi, thanks to your reply.

Yes I did create a field combine the seller and buyer. But the new field is not linked to the seller or buyer. When I select from the new field, there is not reaction from the seller or buyer. How should I deal with this situation? Thanks

Re: Multiple Selection in QlikView

tresB — Tue, 01 Aug 2017 06:19:43 GMT

That is what I suggested/showed you creating a trigger for.

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 06:27:38 GMT

I see. Many thanks!

But I want records shown in both fields. Is there any way?

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 06:32:44 GMT

Oh, it indeed can choose from both sides. But the format is not what I want. It is combining the two sides like AB, BC together. And your choice becomes AB, BC. But I just want to choose A or B alone.

Re: Multiple Selection in QlikView

tresB — Tue, 01 Aug 2017 06:33:01 GMT

If your Buyer and Seller are from same table or associated, then seeing of both the fields values depends on their association. For example, in your sample above, if you select 'A' from Seller, your Buyer 'A' goes out of scope ; so you can't select 'A' from Buyer.

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 06:35:45 GMT

Oh, anyway I appreciate your help. But that's not what I want.

I just want to select like, a content, a content that is included in both two fields so that once I select this content, records from two fields will be filtered.

Re: Multiple Selection in QlikView

tresB — Tue, 01 Aug 2017 06:38:20 GMT

Let me repeat it, 'that (it's possibility, the way you want) depends on their association'.

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 06:40:14 GMT

Yes, I know what you mean.

But I don't have this kind of association and I still want two fields records to show.

Re: Multiple Selection in QlikView

tresB — Tue, 01 Aug 2017 06:43:12 GMT

Could you post a sample qvw that mimic your data?

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 06:46:50 GMT

Just like the sample table in my question.

If I select A, I want both sides to give me the records that contain A. No matter the association is what.

What you did is, only if there is a pair of record 'Seller A and Buyer A', A will show in both sides. It's no difference from selecting directly from Seller or Buyer.

Re: Multiple Selection in QlikView

tresB — Tue, 01 Aug 2017 06:51:45 GMT

Have you tried selecting (manually) 'A' from both the fields in your sample data set qvw? Is it working?

Re: Multiple Selection in QlikView

Tue, 01 Aug 2017 06:56:17 GMT

You mean, create two list box from seller and buyer respectively and select A from these two boxes? I don't think this selection can be done simultaneously, cause once you select in one side, there will be records filtered out from the other side. Just as what you said 'depends on their association'.