Marketing skills to Employee search

[#1]

Hello,

Below is how I loaded Employee data with individual skills while loading data into Qlikview. My client now wants to display all employees having skills Spanish, Sociology and Marketing. If use listbox for selection it displays OR kind of result which means all employees having either Spanish OR Sociology OR Marketing will be displayed. How do I change it to AND?

Basically I want to display all employees having skills Spanish AND Sociology AND Marketing. I tried all sort of search like fuzzy, advance search but no luck.

Abhijeet

[swuehl]

seems to me like you want to have a look at AND-mode list boxes:

AND-Mode

AND and OR

[vikasmahajan]

may this useful for you https://community.qlik.com/docs/DOC-6828

HTH

Vikas

[#4]

Thank you Swuehl,

AND mode list box solved my problem