topic One filter, two columns in QlikView https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562042#M209750 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I need <STRONG>one</STRONG> country filter which work with two columns in a table.</P><P></P><P>Please see the attach file!</P></BODY></HTML> Wed, 10 Jul 2013 16:01:49 GMT farolito20 2013-07-10T16:01:49Z One filter, two columns https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562042#M209750 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I need <STRONG>one</STRONG> country filter which work with two columns in a table.</P><P></P><P>Please see the attach file!</P></BODY></HTML> Wed, 10 Jul 2013 16:01:49 GMT https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562042#M209750 farolito20 2013-07-10T16:01:49Z Re: One filter, two columns https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562043#M209751 <HTML><HEAD></HEAD><BODY><P>Can you upload an example just to konw the data and expressions you are using?</P><P></P><P>I would suggest you to create a field with data from both</P><P>Buy Country and Sell Country</P><P>and then use the field in a List </P></BODY></HTML> Wed, 10 Jul 2013 16:06:11 GMT https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562043#M209751 anandathome 2013-07-10T16:06:11Z Re: One filter, two columns https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562044#M209752 <HTML><HEAD></HEAD><BODY><P>But, how connect the list with <SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Buy Country and Sell Country</SPAN>?</P></BODY></HTML> Wed, 10 Jul 2013 16:29:09 GMT https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562044#M209752 farolito20 2013-07-10T16:29:09Z Re: One filter, two columns https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562045#M209753 <HTML><HEAD></HEAD><BODY><P>Add a Select in Field action to OnSelect field trigger of the field BUY ORIGIN. The field to select <EM>in</EM> would be SALE ORIGIN. The search string would be ='(' &amp; concat(distinct chr(34) &amp; [SALE ORIGIN] &amp; chr(34), '|',) &amp; ')'</P><P></P><P>When you select countries in BUY ORIGIN the same countries will be selected in SALE ORIGIN.</P></BODY></HTML> Thu, 11 Jul 2013 16:43:30 GMT https://community.qlik.com/t5/QlikView/One-filter-two-columns/m-p/562045#M209753 Gysbert_Wassenaar 2013-07-11T16:43:30Z