topic Re: Search Function in QlikView

Search Function

Mon, 26 Oct 2015 11:09:24 GMT

Hi,

I have concatenated 8 fields into one field to enable the user to 'wildcard' search only these fields for a particular value. Since giving the user this option, they have asked if it is possible to search this field for two different values. I have said that this inst possible using the current search facility is this correct?

Thanks for any help

Re: Search Function

marcus_sommer — Mon, 26 Oct 2015 11:13:33 GMT

You could combine several wildcard-searches with this syntax:

("*value1*"|"*value2*")

- Marcus

Re: Search Function

jonathandienst — Mon, 26 Oct 2015 11:17:46 GMT

I assume that you are searching in a list box. You can enter multiple criteria using the syntax

(search1|search2) where searchn can contain * as a wildcard

For example values contain "hello" or "goodbye" (*hello*|*goodbye*).

Quote the search strings if they contain spaces.

Re: Search Function

jonathandienst — Mon, 26 Oct 2015 11:22:56 GMT

If the users find this confusing, train them to search and select the first value, then search and ctrl-select the second value.

You might want to consider using the Search sheet object, which can search multiple fields at once. Then it will not be necessary to create a concatenated search string which will of necessity be both long and have a high cardinality - both of which can impact performance on a large models.