Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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

Highlighted
Digital Support
Digital 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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
Digital Support
Digital 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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
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.

Highlighted
Digital Support
Digital 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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Highlighted
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

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

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