Marketing skills to Employee search - Qlik Community

Report Inappropriate Content · ‎2016-03-07

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 · ‎2016-03-07

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

AND-Mode

AND and OR

vikasmahajan · ‎2016-03-08

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

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2016-03-08

Thank you Swuehl,

AND mode list box solved my problem