Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Partner
Partner

Or-mode selections between list boxes

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

10 Replies
MVP & Luminary
MVP & Luminary

Re: Or-mode selections between list boxes

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

Support
Support

Re: Or-mode selections between list boxes

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Support
Support

Re: Or-mode selections between list boxes

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Partner
Partner

Re: Or-mode selections between list boxes

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

Support
Support

Re: Or-mode selections between list boxes

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
MVP & Luminary
MVP & Luminary

Re: Or-mode selections between list boxes

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

MVP & Luminary
MVP & Luminary

Re: Or-mode selections between list boxes

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

Luminary
Luminary

Re: Or-mode selections between list boxes

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

Partner
Partner

Re: Or-mode selections between list boxes

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