
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In search box properties, use Fuzzy search
-Sundar

.png)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can make a composite search using (Adam|Brian|Carl)
HIC

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
In searchbox (not listbox search) this seems to work:
(brian?smith|brian?anderson)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
do you need the question marks in there for it to work? it does not recognize regular spaces?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes, no

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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*")

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- « Previous Replies
-
- 1
- 2
- Next Replies »