Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
VivenReddy
Partner - Creator
Partner - Creator

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
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
Former Employee
Former Employee

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.
Brett_Bleess
Former Employee
Former Employee

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.
VivenReddy
Partner - Creator
Partner - Creator
Author

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
Former Employee
Former Employee

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.
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Luminary Alumni
Luminary Alumni

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

VivenReddy
Partner - Creator
Partner - Creator
Author

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