topic Re: Finding related records in QlikView https://community.qlik.com/t5/QlikView/Finding-related-records/m-p/521179#M194734 <HTML><HEAD></HEAD><BODY><P>You can use a Select in Field action assigned to the OnSelect trigger of the field in the listbox. Choose as Field the field that contains the similar values you want selected. Use as search string ='(' &amp; concat(distinct '*' &amp; ItemCode &amp; '*', '|') &amp; ')'. Replace ItemCode with the actual name of the field in your listbox.</P></BODY></HTML> Sat, 14 Sep 2013 09:57:15 GMT Gysbert_Wassenaar 2013-09-14T09:57:15Z Finding related records https://community.qlik.com/t5/QlikView/Finding-related-records/m-p/521178#M194733 <HTML><HEAD></HEAD><BODY><P>list box has a list of item codes</P><P>table has records with item codes that are similar</P><P></P><P>how do I select records in the table that are similar to the selected value from the list box, that is, the values in the table will be "like" the value in the table?</P></BODY></HTML> Fri, 13 Sep 2013 22:04:34 GMT https://community.qlik.com/t5/QlikView/Finding-related-records/m-p/521178#M194733 2013-09-13T22:04:34Z Re: Finding related records https://community.qlik.com/t5/QlikView/Finding-related-records/m-p/521179#M194734 <HTML><HEAD></HEAD><BODY><P>You can use a Select in Field action assigned to the OnSelect trigger of the field in the listbox. Choose as Field the field that contains the similar values you want selected. Use as search string ='(' &amp; concat(distinct '*' &amp; ItemCode &amp; '*', '|') &amp; ')'. Replace ItemCode with the actual name of the field in your listbox.</P></BODY></HTML> Sat, 14 Sep 2013 09:57:15 GMT https://community.qlik.com/t5/QlikView/Finding-related-records/m-p/521179#M194734 Gysbert_Wassenaar 2013-09-14T09:57:15Z