topic Re: Or selections for list box in QlikView

Or selections for list box

alexpanjhc — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Or selections for list box

jwjackso — Wed, 14 Mar 2018 23:15:15 GMT

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.

Re: Or selections for list box

Siva_Sankar — Thu, 15 Mar 2018 01:16:57 GMT

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

Re: Or selections for list box

alexpanjhc — Thu, 15 Mar 2018 20:55:13 GMT

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

Re: Or selections for list box

swuehl — Thu, 15 Mar 2018 21:41:23 GMT

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.

Re: Or selections for list box

alexpanjhc — Fri, 23 Mar 2018 21:05:31 GMT

Steve

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