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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

OR selection in list box

Hi,

I have 3 list boxes  as below and want to do the OR selection in listbox as below.

AssignedGroupManager =  “Jason Schlagel” OR AssignedManager = “Jason Schlagel” OR AssignedManager = “Brandon Ly” OR Assigned = “Jason Schlagel”.

I want to allow user to do the OR selection. If you see I have selected AssignedGroupManager =  “Jason Schlagel” so I can not see  Assigned = “Jason Schlagel”.

Thanks

2 Replies
giakoum
Partner - Master II
Partner - Master II

Obviously values exclude each other.

You can either create data isalnds with the fields or use alternate states and amend your expressions accordingly.

Hope this helps!

Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Alternate states are your best bet. See for example Using Alternate States to Select Multiple Values in a List Box with Different Attributes

You can also try this: http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/


talk is cheap, supply exceeds demand