topic Re: Multiple field search in QlikView

Multiple field search

Wed, 10 Dec 2014 15:27:09 GMT

I have 2 fields which could contain an Account Name. I want to look in the 2 fields and pull all data from the fields containing the name. The Account name could be spelled differently in each. I do not want the user to have to do a global search and then select all matching values

Example:

AccountName =Design Studio

ProjectName = DesignStudio

I created an input box for the user to enter the name(s) and store into a variable. I created 2 list boxes, one for AccountName and one for ProjectName. I had to use Alternate state on each. I set a trigger on the variable from the input box to select the matching values in the 2 list boxes. I now want to take the values in each box and apply to my chart. How do I get this to work?

Re: Multiple field search

MarcoWedel — Wed, 10 Dec 2014 20:44:16 GMT

Maybe a search box restricted to search only in your Account- and ProjectName fields could be a solution.

You could also change the search mode to match your requirements.

hope this helps

regards

Marco

Re: Multiple field search

prieper — Wed, 10 Dec 2014 21:17:52 GMT

You may also concatenate both fields and display in a listbox (with seach-functionality).

HTH Peter

Re: Multiple field search

Wed, 10 Dec 2014 21:27:07 GMT

I have tried the concatenated listbox but cannot get the "Input box" value to select the possible values.

Re: Multiple field search

MarcoWedel — Wed, 10 Dec 2014 22:49:26 GMT

Hi,

maybe like this:

=ValueList($(=chr(39)&GetFieldSelections(AccountName,chr(39)&','&chr(39))&chr(39)),$(=chr(39)&GetFieldSelections(ProjectName,chr(39)&','&chr(39))&chr(39)))

hope this helps

regards

Marco