Searching for multiple values

[tresesco]

say, i have a list box with many values(Names). i have a list of names somewhere in my another document (in mail). i need to find the values corresponding to those names. i want to copy those names (from mail) and want the selection to take place for those names. how can that be done?

Regards, tresesco

[ashfaq_haseeb]

HI Tresco

Use Search Object In qlikview

I think its available from V 10 onwards

Regards

ASHFAQ

[tresesco]

Thanks Ashfaq for your reply. Can you please guide me a bit more? i am not getting it(search object). and suggest if there is any other trick to do the same (because my most of the environments are QV9).

[#4]

Hello tresesco,

the search-syntax for a list of different names is (name1|name2|name3). So if you can achieve to built your list in this way then it is possible to copy/paste it "into" the listbox.

Regards, Roland

[tresesco]

i think its not a good idea to change the presentation of the list box. let the list box be intact at its place. because the users would not like to see the names as - name1|name2|name3..... any other idea?

Regards, tresesco

[#6]

Hello again,

I do not want to change the listbox itself. What I mean is the searchsyntax for listboxes is using brackets "()" and the pipesymbol "|" between two search-expressions similar to "(find1|find5|find7)". Try to put it into the searchfield of a listbox (without the "") to see what's happening.

RR

[Miguel_Angel_Baeyens]

Hi,

Although I don't know whether the following may help, it might worth trying. Use a variable that stores the values of the names in a usable format for say, set analysis:

=chr(39) & Concat(Distinct Name, chr(39) & ',' & chr(39)) & chr(39)

You can use it later in you expressions:

Sum({< Name = {$(vNames)} >} Amount)

Hope that helps.

[tresesco]

Thanks Roland, though this not what i exactly wanted, still at least something helpful. after copy/paste the users will have to take the overhead of putting pipe in between. can you come with a bit more help/idea, if this pipelining can be automated ?

Regards, tresesco

[prieper]

Think that John has posted recently a nice solution for this problem:

http://community.qlik.com/forums/p/31122/151029.aspx#151029

HTH
Peter

[tresesco]

Thank you all. @Miguel : Let me explain the scenario. I am given a list of 50 names and said to make a report against those names taking them together/in a group. Now i want to avoid the overhead of selecting all 50 names one by one keeping CTRL key pressed. It�s a daily task. So there should be an easy way out, like copy/paste and get the selection happen kind of thing. @Peter : thank you for the information. but unfortunately now i can't download the application uploaded by John, so i would definitely look at it when get the chance. Regards, tresesco