topic Re: Or-mode selections between list boxes in QlikView

Or-mode selections between list boxes

VivenReddy — Wed, 04 Sep 2019 15:58:01 GMT

I need 2 list boxes to behave in OR mode when i make selections in both. As you know by default selections between objects in Qlikview are in AND mode.

There have been some posts about this in 2013 (notably the one from Barry Harmsen - http://www.qlikfix.com/2013/10/23/and-or-mode-selections-in-qlikview/). Since then has Qlik done anything to make this easier to achieve?

Can someone please point me to a solution? Or does someone have the example file that Barry attached in the post above (as its no longer available on that url)?

Re: Or-mode selections between list boxes

marcus_sommer — Thu, 05 Sep 2019 13:15:07 GMT

A possibly easier approach might be (in regard to Barry's example):

sum({1< [Customer] = p()> + < [Product] = p()> + < [Salesman] = p()>} Sales)

but I get the feeling that I missed something essential because it looked to easy ... Nevertheless this approach might be helpful for your tasks.

- Marcus

Re: Or-mode selections between list boxes

Brett_Bleess — Tue, 17 Sep 2019 21:43:06 GMT

Viven, see the following Help link, OR is the default, not AND...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/List_Box.htm

Multiple selections within a field must be of either AND or OR type. By default, the selection is of OR type. This command toggles the logical mode by which multiple value selections are made. This menu option is disabled if the field does not satisfy certain conditions. This option is not available for calculated fields.

Regards,
Brett

Re: Or-mode selections between list boxes

Brett_Bleess — Tue, 17 Sep 2019 21:45:37 GMT

Realized I may have screwed up after all here, here are a couple of Design Blog posts I hope may help as well, I think you meant between the list boxes, sorry, got confused with the settings inside the List box, but hopefully one of the posts may help:

https://community.qlik.com/t5/Qlik-Design-Blog/AND-and-OR/ba-p/1466634

https://community.qlik.com/t5/Qlik-Design-Blog/AND-Mode/ba-p/1471352

Best I have, sorry for my confusion on the first post!

Regards,
Brett

Re: Or-mode selections between list boxes

VivenReddy — Wed, 18 Sep 2019 16:56:51 GMT

Thanks for responding Brett. However it seems like the links in both your responses are referring to AND and OR within one list box.

Re: Or-mode selections between list boxes

Brett_Bleess — Wed, 18 Sep 2019 17:23:34 GMT

Viven, yeah, sorry about that, I was afraid I was on the wrong track after I reread things. Unfortunately I am not a very good developer either, but there is someone else I can reach out to to have a look at things, may take a day or two, but let me do that to see if they have any ideas, I do not even want to guess at anything else for fear of sending you down the proverbial rabbit hole here.

Cheers,
Brett

Re: Or-mode selections between list boxes

rwunderlich — Thu, 19 Sep 2019 04:52:07 GMT

I can suggest some solutions using sets and/or alternate states depending on your use case. Offhand, I can't think of a way to treat "everything as an OR". But if you are dealing with specific known fields, I can suggest some solutions. Can you describe your use case?

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

Re: Or-mode selections between list boxes

marcus_sommer — Thu, 19 Sep 2019 06:08:12 GMT

Here is a quite similar solution from Sunny in regard to my suggestion which didn't used the 1 as set identifier else it ignored (some of the) possible selections within the set modifier and it contains also an example how it's done:

QlikView-OR-filter-using-set-Analysis

- Marcus

Re: Or-mode selections between list boxes

barryharmsen — Thu, 19 Sep 2019 09:28:33 GMT

Barry here, I've attached the file from my blog.

Re: Or-mode selections between list boxes

VivenReddy — Thu, 19 Sep 2019 17:44:53 GMT

Thank you all for the suggestions. Let me take a look and see which option works best for me.

Re: Or-mode selections between list boxes

rwunderlich — Fri, 20 Sep 2019 04:38:23 GMT

Here's another example using Alternate States.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com