Or selections between list boxes

[#1]

hi everyone!

i want to know if it is possible do an "or" selections between list boxes.

I found this post, but no one could help me because they talk about "and" selections in the same list box.

http://community.qlik.com/thread/38610

http://community.qlik.com/message/127398#127398

http://community.qlik.com/message/118112#118112

thank you!

gerardo

[swuehl]

Maybe like discussed here?

http://community.qlik.com/thread/7773

[#3]

well.....firts at all my question have an answer: NO, and the workaround explained there is too complex. Maybe if i describe my problem you can help me.

here is de mysql syntax i need to translate into qlikview:

"select s.id, u.name, s.is_tourism, u.id

from deals s, companies u

where s.is_tourism = 1

or u.id in ('157', '18', '498')

and s.company_id = u.id

group by s.id"

so in one hand i have deals which are in tourism group and in another hand deals which are inside ('157', '18', '498') companies. Because of this when i choose is_tourism = 1 in a list box the others deals inside  ('157', '18', '498') companies disappear.

thanks

gerardo

[swuehl]

Do you want a static selection? Then you can probably just reuse your mysql statement in the script.

If you want to have an OR selection in the UI, allowing different selection values on runtime, I think you can achieve what you want using associative search (Needs QV10 and up!).

Open the search bar in list box e.g. deals, click on the chevron to activate associative search.

Then first select is_tourism=1 by entering 1 and select the appropriate field. then search for the company IDs, but press CTRL while selecting and entering, so you add to your existing selection in deals field.

Not sure if I make myself clear, but using associative search together with CTRL actually allows a OR selection, since you don't actually select on your fields is_tourism and company_ids, thus not following selections.

Just give it a try.

-- Stefan

[#5]

bad news....all selections need to have some relationship. In my case company 18 don't have is_tourism= 1 deals.

So, when i choose is_tourism=1 im not allow to choose company 18....

[swuehl]

That's not what I meant...

You don't select neither on is_tourism nor on company field directly. Instead you select on deals field (whatever its name is), using associative search.

[#7]

well....the same happen but in the associative search box.....im allow to choose just one of those....

[swuehl]

Yes, you should do the selections sequentially, using CTRL to add your associative selections in field deals.

[#9]

sure.....i did it, but with the same result

[swuehl]

Could you upload a small sample? then I could probably explain better what you need to do step by step, or could check why it is not working with your data model.