Comma separated searches

[#1]

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

[sundarakumar]

In search box properties, use Fuzzy search

-Sundar

[hic]

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

HIC

[#4]

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]

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

(brian?smith|brian?anderson)

[#6]

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

[rbecher]

Yes, no

[maxgro]

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*")

[#9]

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

[#10]

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