topic AW:Searching for multiple values in QlikView

Searching for multiple values

tresB — Mon, 07 Mar 2011 08:06:15 GMT

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

Searching for multiple values

ashfaq_haseeb — Mon, 07 Mar 2011 08:08:29 GMT

HI Tresco

Use Search Object In qlikview

I think its available from V 10 onwards

Regards

ASHFAQ

Searching for multiple values

tresB — Mon, 07 Mar 2011 08:34:24 GMT

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

AW:Searching for multiple values

Mon, 07 Mar 2011 09:42:50 GMT

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

AW:Searching for multiple values

tresB — Mon, 07 Mar 2011 11:15:43 GMT

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

AW:Re: AW:Searching for multiple values

Mon, 07 Mar 2011 11:22:20 GMT

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.

AW:Searching for multiple values

Miguel_Angel_Baeyens — Mon, 07 Mar 2011 11:27:35 GMT

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.

AW:Re: AW:Searching for multiple values

tresB — Mon, 07 Mar 2011 11:37:33 GMT

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

AW:Re: AW:Searching for multiple values

prieper — Mon, 07 Mar 2011 12:17:13 GMT

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

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

HTH
Peter

AW:Re: AW:Searching for multiple values

tresB — Mon, 07 Mar 2011 17:17:46 GMT

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

Re: Searching for multiple values

Thu, 09 Jun 2016 10:06:08 GMT

Hi Tresesco,

Did you get any luck on this!!! if so kindly let me know.

Regards

John