topic Re: Search multiple words in QlikView

Search multiple words

gilldilpreet — Sat, 16 Nov 2024 00:24:02 GMT

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

Re: Search multiple words

rubenmarin — Tue, 30 Jun 2020 15:35:16 GMT

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.

Re: Search multiple words

vamsee — Tue, 30 Jun 2020 15:36:26 GMT

I hope I got your question right.

Two ways to do this

Search one course after the other and keep selecting
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.

Re: Search multiple words

vamsee — Tue, 30 Jun 2020 15:38:12 GMT

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