topic Or selections between list boxes in QlikView

Or selections between list boxes

Wed, 04 Jan 2012 12:49:03 GMT

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

Or selections between list boxes

swuehl — Wed, 04 Jan 2012 13:09:10 GMT

Maybe like discussed here?

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

Or selections between list boxes

Wed, 04 Jan 2012 13:35:14 GMT

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

Or selections between list boxes

swuehl — Wed, 04 Jan 2012 14:33:46 GMT

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

Or selections between list boxes

Wed, 04 Jan 2012 14:58:36 GMT

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....

Re: Or selections between list boxes

swuehl — Wed, 04 Jan 2012 15:03:46 GMT

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.

Or selections between list boxes

Wed, 04 Jan 2012 15:10:17 GMT

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

Or selections between list boxes

swuehl — Wed, 04 Jan 2012 15:14:08 GMT

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

Or selections between list boxes

Wed, 04 Jan 2012 15:19:15 GMT

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

Or selections between list boxes

swuehl — Wed, 04 Jan 2012 15:25:37 GMT

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.

Or selections between list boxes

Wed, 04 Jan 2012 15:58:13 GMT

i attached a sample in the main question....thanks!

Or selections between list boxes

swuehl — Wed, 04 Jan 2012 16:33:55 GMT

Well, skip the associative search for now...

Open search bar on field DEALS.deal_id and enter

=match(COMPANIES.company_id,157,18,498) or DEALS.is_tourism=1

I get 588 deal IDs returned.

If I select only DEALS.is_tourism=1, I get 401 deals.

If I select only COMPANIES.company_id 157 and 18, 187 deals.

Since company_id 498 is also is_tourism=1, this looks reasonably to me.

--Stefan

Or selections between list boxes

Wed, 04 Jan 2012 17:27:20 GMT

im doing something wrong.....because that give me the deals from the first condition (COMPANIES.company_id,157,18,498) but not from the second part (DEALS.is_tourism=1) and the search bar look for "or" text criteria....

thanks

Re: Or selections between list boxes

swuehl — Wed, 04 Jan 2012 22:48:47 GMT

What do you mean with "..the search bar look for "or" text criteria..."

Just to clarify, I am not talking about the search object (well, haven't tried with that), I am talking about the search field that you get when clicking on the caption of the list box and start typing or by clicking on the magnifying glass.

Then you maybe need to clear the field from wildcards * and enter the complete line exactely as given here:

=match(COMPANIES.company_id,157,18,498) or DEALS.is_tourism=1

Hope this helps,

Stefan

Re: Or selections between list boxes

Thu, 05 Jan 2012 15:00:18 GMT

excellent! its working very well.....

now....can i do something more "user friendly" with this?

thank you very much.....

Re: Or selections between list boxes

swuehl — Thu, 05 Jan 2012 15:09:43 GMT

Sure, but since we started with a reference thread that involved too much complexity, we need to check what is the right level of complexity.

You could for example create a variable with an input box for the companies id, and create a button with action select in field for field deals and an appropriate search string. If I find time, I will post a proposal.

Do you think that will help your users?

edit: Attached sample

Or selections between list boxes

Thu, 05 Jan 2012 15:21:28 GMT

of course that can help.

And not only for this case but olso for others situations that i haven't resolved yet...

Or selections between list boxes

swuehl — Thu, 05 Jan 2012 15:56:10 GMT

Hope you have noticed my above edit. Something like this?

Or selections between list boxes

Thu, 05 Jan 2012 16:24:44 GMT

yes, the bottom is perfect.

thanks!