topic Re: OR selection in list box in QlikView

OR selection in list box

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: OR selection in list box

giakoum — Tue, 29 Nov 2016 09:25:19 GMT

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!

Re: OR selection in list box

Gysbert_Wassenaar — Tue, 29 Nov 2016 09:33:00 GMT

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/