Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Qlikview Boolean Search

I sort of understand Searches in Qlikview are OR by default and also looked into ANDMode which seemed to work.
What I need is a complex searching method for the user.
For example, if the column product has a list of fruits, I need let the user enter :

(Apples and Oranges) or (Apples and Bananas) in their search string / search box.

Doing an or in a regular search box selects works, but things get tricky when I want to get both boolean operations (and/or) in the same search box. (Would prefer user to type in the boolean search rather than select from a list)

Any help would be deeply appreciated.

Thank you

3 Replies
Contributor II
Contributor II

I did, but most of them explain how to search with the list. For example, the links above show me how to search for apples and/or oranges in the list box or search box, but they do not filter my data based on said search criteria.
If that made any sense. Sorry its clear in my head, but might not be as clear when I try to explain it.

Digital Support
Digital Support

Vivek, did you have a look at the Expression Search?


Here is the Help, not a ton there, but you can pretty much do whatever you want this way, unfortunately I am not a very good developer to come up with the expression you need here to do what you want...


Sorry I do not have anything better, my post will kick things back up, so maybe someone else will see things and offer up something different for you to try.


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.