Searching a list of values in QlikView

[#1]

Hi,

We all know the possibility to search a single value through the Search Object. But how can I search for a list of values?

Thanks,

Guy

[Miguel_Angel_Baeyens]

Hi Guy,

Use this syntax in the search object to search for words starting on "A" or "B" or "C"

(A*|B*|C*)

Hope that helps.

Miguel

[#3]

I meant other thing:  lets say i have a list of Unique Numbers in an Excel sheet, and i want all of them to be searched in my documents at once.

[Miguel_Angel_Baeyens]

Hi,

If you mean you have all those values in a field named UniqueNumber you can use the function

Concat(DISTINCT UniqueNumber, '|')

Is that what you were looking for?

Miguel

[swuehl · Accepted solution]

Not sure if I've understood what you are after, could you give an example?

If you don't want to use what Miguel suggested, I remember some threads here in the forum that talked about using an input box for the import of search values (copy & paste from an (excel) file). For the moment, only found

http://community.qlik.com/message/183175

[#6]

Thanks! That is what i need. A place that a user can copy a list of values to be searched, so he would not have to search for each one of them seperately.

[#7]

Thank u....:)