Or selections for list box

[alexpanjhc]

Hi All

I hope this is simple question

I have one set of list boxes,

one list box is primary owner and the other one is secondary owner,

what do I do so that I can select the  the primary owner is A or secondary owner is B?

Primary Owner	Secondary Owner	ShipID
A	B	1
A	C	2
C	B	4

when I select Primary owner A and secondary Owner is b

ShipID 1 and 4 will show?

thanks!

[jwjackso]

I believe C and B will give you ShipID 1 and 4, A and B should give you 1, 2 and 4.

I had a similar need, so I used alternate  states.  In the attached app, I selected Primary Owner = C and pressed the "Copy Default State to Alternate State1", I then pressed the "Clear Default State".

I selected Secondary Owner = B and pressed the "Copy Default State to Alternate State2", I then pressed the "Clear Default State".

The "Set State Filter" creates a set analysis statement that is used to calculate the number of ShipID's, I suppress for zero

=If(Count( $(=(vStateFilter)) Distinct ShipID) < 1,Null(),Count( $(=(vStateFilter)) Distinct ShipID))

The "Build Filter form Excel data was also part of the POC,  you can copy a column of data from Excel and generate a filter.

This was built for a specific need, but at the least it demonstrates alternate states.

[Siva_Sankar]

http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/

[alexpanjhc]

Thank you for your responses and I will take a look at the articles.

[swuehl · Accepted solution]

You can also load this table twice and transform your two owner fields into one concatenated field and a owner type field that tags the owner according the original field.

Now you can select all owners in one list box, OR condition by default.

You still can filter primary and secondary owners by owner type field.

You can also keep the original table, if needed, so these tables would link by ShipID and you have most flexible ways to use the owner information.

[alexpanjhc]

Steve

what about a field in two tables and the two tables do not have a common keys, how do you deal with that?