topic Re: Select all fields where value occur in QlikView

Select all fields where value occur

Thu, 08 Aug 2013 14:17:57 GMT

I've got 3 fields; ID, Name1, Name2. I've created an input box with a list of all the names that may occur in either field. Now I want to create a Select field-action that finds any occurence of the name. I guess I need to create a fourth field in the script that merges all names, and then do a wildcard search in that field and select the ID-field when a match is found. If that is the correct solution, what is then the correct search string syntax?

Example:

ID	Name1	Name2
1	John	John
2	Lisa	Anna
3	John	Ruth
4	Anna	Peter
5	Peter	John

If I select "John" in the input box the following should be selected:

ID	Name1	Name2
1	John	John
3	John	Ruth
5	Peter	John

How do I accomplish this?

Thanks in advance

Re: Select all fields where value occur

swuehl — Thu, 08 Aug 2013 14:41:05 GMT

IMHO, selecting in ID field is the right approach.

You can create a Select - Select in field action for a button action and then create a search string like

='=Name1=' &chr(39)& $(vInputBox) &chr(39) ' or Name2=' &chr(39)& $(vInputBox) &chr(39)

Re: Select all fields where value occur

Fri, 09 Aug 2013 05:53:47 GMT

Excellent, thank you a lot! There was an ampersand missing and by removing the $-sign (don't know what it does). I got it working with this formula:

='=Name1=' &chr(39)& vInputBox &chr(39) & ' or Name2=' &chr(39)& vInputBox &chr(39)