Or-mode selections between list boxes

[VivenReddy]

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)?

[marcus_sommer]

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

[Brett_Bleess]

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

[Brett_Bleess]

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

[VivenReddy]

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

[Brett_Bleess]

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

[rwunderlich]

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

[marcus_sommer]

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

[barryharmsen]

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

[VivenReddy]

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