topic Re: Qlikview Boolean Search in QlikView

Qlikview Boolean Search

padmanabhv — Wed, 20 Nov 2019 03:48:26 GMT

Hi,
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

Re: Qlikview Boolean Search

MindaugasBacius — Wed, 20 Nov 2019 06:05:39 GMT

Try looking:

https://community.qlik.com/t5/Qlik-Design-Blog/The-Search-String/ba-p/1470548

https://community.qlik.com/t5/Qlik-Design-Blog/Text-searches/ba-p/1464217

Re: Qlikview Boolean Search

padmanabhv — Wed, 20 Nov 2019 16:19:29 GMT

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.

Re: Qlikview Boolean Search

Brett_Bleess — Wed, 04 Dec 2019 16:51:44 GMT

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

https://community.qlik.com/t5/Qlik-Design-Blog/The-Expression-Search/ba-p/1463907

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...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Advanced_Search.htm

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.

Regards,
Brett