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: 
simonb2013
Creator
Creator

Muli Select : 'And' instead of 'Or'

As I'm only on day 2, I'm sure this is a 'stupid noob' question ... but anyway ....

Let's say my main table looks like this:

BasketFruit

Blue

Orange
BlueBanana
BlueGrapefruit
GreenOrange
GreenPear
YellowBanana
YellowPear
YellowMango

Now what I need, is for a user to be able to find which Basket contains both a Banana and an Orange.

I can do this in a relational DB quite easily, but the structure & functionality of things in QV have me a little at a loss.

Would anyone be able to point me in the right direction ?

Any help muchly appreciated

2 Replies
swuehl
MVP
MVP

You can look into the And Mode list box, there is a chapter in the Help / reference manual about that.

Siva_Sankar
Master II
Master II

refer the attached example