Search multiple words

[gilldilpreet]

Hi,

I am trying to use the search bar object to search mulitple words.The field I am using is Course title so I would like my results to show all course titles with the searched words in the title i.e. a search for 'history' 'art' 'literature' would return courses with EITHER of these words in the title (not necessarily all the words in the same title), if that makes sense.

Thanks in advance for your help!

Dilpreet

[rubenmarin · Accepted solution]

Hi, if you use the search object an empty space can be used as an or. Note that oyu can't use wildcard, by default is a wildcard search. So if you search by "ins dir" (without the double qutes) will look for texts with ins, dir or both in the text.

[vamsee]

I hope I got your question right.

Two ways to do this 

1. Search one course after the other and keep selecting
2. Create a table (inline or excel) with Search text and Value, something like a grouping table and join/applymap it to the main table

Course Title	Search
HISTORY	Social
ART	Social
LITERATURE	Social
HISTORY	HISTORICAL STUDIES
ART	HISTORICAL STUDIES
LITERATURE	HISTORICAL STUDIES
HISTORY	US HISTORY
ART	US HISTORY
LITERATURE	US HISTORY

So if a search for US History is made then all three History, Art and Literature would be the possible courses.

[vamsee]

If you are referring to wildcards refer https://community.qlik.com/t5/QlikView-Layout-Visualizations/Searching-using-Wildcards/m-p/415509

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/Text_search_and...