topic Button to search fields in QlikView https://community.qlik.com/t5/QlikView/Button-to-search-fields/m-p/528616#M550046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Id like to make a single button that searches 4 fields. It will need to look at the 4 fields and find anywhere that it says "Yes". I did this already by making a button with 4 "Select in field" actions and have each be 1 of my fields and search string = *Yes*.</P><P></P><P>This does not meet the requirement though. This will find only rows that have "Yes" in all 4 fields, not just finding the rows that could have "Yes" in one of the fields. If someone has a suggestion that would be great!</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 04 Dec 2013 15:20:54 GMT 2013-12-04T15:20:54Z Button to search fields https://community.qlik.com/t5/QlikView/Button-to-search-fields/m-p/528616#M550046 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Id like to make a single button that searches 4 fields. It will need to look at the 4 fields and find anywhere that it says "Yes". I did this already by making a button with 4 "Select in field" actions and have each be 1 of my fields and search string = *Yes*.</P><P></P><P>This does not meet the requirement though. This will find only rows that have "Yes" in all 4 fields, not just finding the rows that could have "Yes" in one of the fields. If someone has a suggestion that would be great!</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 04 Dec 2013 15:20:54 GMT https://community.qlik.com/t5/QlikView/Button-to-search-fields/m-p/528616#M550046 2013-12-04T15:20:54Z Re: Button to search fields https://community.qlik.com/t5/QlikView/Button-to-search-fields/m-p/528617#M550047 <HTML><HEAD></HEAD><BODY><P>I would suggest creating a new field with a hidden prefix in your script.&nbsp; Then you use a select in field action based on that field instead of your four fields.&nbsp; See attached.</P></BODY></HTML> Wed, 04 Dec 2013 15:59:25 GMT https://community.qlik.com/t5/QlikView/Button-to-search-fields/m-p/528617#M550047 2013-12-04T15:59:25Z