Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Comma separated searches

Hi,

I have a open question (no specific app relations). Is it possible to create a search box that can do multiple searches at the same time by having comma separated entries. The situation I am working with is people getting lists of employees mailed to them (Adam, Brian, Carl ... ) and they would then like to Copy+Paste this string of people directly into a search box and set the filter that way. Or Copy+Paste a list out of Excel into Qlikview.

Im not necessarily looking for a comma separated solution, however some sort of divisor to do enter multiple searches in a Search Box at the same time. Is this possible, and if such - how? I am not to solve this with any script reading or such since I cannot ask the end-users to do so. I just want the Copy + Paste solution.

Cheers,

Nils

16 Replies
sundarakumar
Specialist II
Specialist II

In search box properties, use Fuzzy search

topost.PNG

-Sundar

hic
Former Employee
Former Employee

You can make a composite search using (Adam|Brian|Carl)

Image1.png

HIC

Not applicable
Author

neither of your answers seem to work, since i along with the results also get several unwanted resulst. lets say i have two brians; biran smith, and brian anderson. if i then want to search for them both i would do a (brian smith|brian anderson) search? this results in me still getting ALL brians (brain adams, brian brian ... ) and so on. Is there a spcific way to just search for the two specific brians?

rbecher
MVP
MVP

In searchbox (not listbox search) this seems to work:

(brian?smith|brian?anderson)

Astrato.io Head of R&D
Not applicable
Author

do you need the question marks in there for it to work? it does not recognize regular spaces?

rbecher
MVP
MVP

Yes, no

Astrato.io Head of R&D
maxgro
MVP
MVP

for 2 brian only

("brian smith"|"brian anderson")

for all brian you already know

brian

you can also refine your search using

"",  |  and * ? (1 char), - (to exclude, -brian)

("a?d*"|"brian*")

Not applicable
Author

well, ok i see. the whole point of this was to have a simple way for the users to do multiple searches at the same time, and this is getting to be a bit to complicated... i can imagine no user ever entering that.

comma separated searches i pretty much standard now-a-days and something users would expect i think...

Not applicable
Author

this seems to complicated for any normal user to utilize. for that simple reason i will drop this issue and regard it as "not solved". no user will ever use a search that needs him to input (" NNN NN" | "YYY YYY" | " MM MM") as a search - thats just to complicated... this is a huge development point for Qlikview