topic Re: Comma separated searches in QlikView

Comma separated searches

Fri, 14 Feb 2014 11:56:27 GMT

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

Re: Comma separated searches

sundarakumar — Fri, 14 Feb 2014 12:02:22 GMT

In search box properties, use Fuzzy search

-Sundar

Re: Comma separated searches

hic — Fri, 14 Feb 2014 13:00:13 GMT

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

HIC

Re: Comma separated searches

Fri, 14 Feb 2014 13:22:12 GMT

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?

Re: Comma separated searches

rbecher — Fri, 14 Feb 2014 13:30:06 GMT

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

(brian?smith|brian?anderson)

Re: Comma separated searches

Fri, 14 Feb 2014 13:38:41 GMT

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

Re: Comma separated searches

rbecher — Fri, 14 Feb 2014 13:42:34 GMT

Yes, no

Re: Comma separated searches

maxgro — Fri, 14 Feb 2014 13:59:39 GMT

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

Re: Comma separated searches

Fri, 14 Feb 2014 14:03:34 GMT

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

Re: Comma separated searches

Fri, 14 Feb 2014 14:12:30 GMT

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

Re: Comma separated searches

rbecher — Fri, 14 Feb 2014 14:15:39 GMT

But tell me how a search field could interpret a search entry of 'brian smith' in an search expression like:

- brian OR smith

- brian AND smith

- 'brian smith'

- 'brian?smith'

- 'brian*smith'

etc.

Re: Comma separated searches

Fri, 14 Feb 2014 14:21:58 GMT

simple, tell it to look for a comma (for instance) as a divider between strings. then "brian smith" would search for that entire string when "brian, smith" would search for all brians and all smiths. a search for "brian smith, brain anderson" would yield results for brians smiths and brian andersons. its not that complicated...

Re: Comma separated searches

rbecher — Fri, 14 Feb 2014 14:24:37 GMT

It's just one use case of searching..

Re: Re: Comma separated searches

maxgro — Fri, 14 Feb 2014 14:55:43 GMT

I agree with you, it's too complicated for a user

I tried a different solution, the idea is in the attachment

Thanks for posting this curious question

Re: Re: Comma separated searches

Fri, 14 Feb 2014 15:15:14 GMT

interesting attachment, i will consider it. however i still think the problem is something qlikview internal developers should address, and make the search function "smarter"

Re: Comma separated searches

rbecher — Mon, 17 Feb 2014 18:38:57 GMT

Nice one. However, the double qoutes are not needed:

Let p = '(*' & replace('$(o)', ',', '*|*') & '*)'

Re: Re: Comma separated searches

vbeachii — Tue, 20 Nov 2018 18:42:14 GMT

I agree. I used to use Microstrategy (another type of BI application) and it would allow me to import comma delimited files with, for example, prescription names I wanted to filter out. This was so easy and efficient. Nobody wants to go through an application and click on each single drug they would like to filter out, especially if there are 200+ drug names.