topic Combine 2 columns for filter .. union ? in QlikView https://community.qlik.com/t5/QlikView/Combine-2-columns-for-filter-union/m-p/307844#M1192660 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><STRONG>Problem: </STRONG> If every transaction has a buy &amp; a sell currency. I am aiming to return any row which has a particluar currency as either BUY or SELL or BOTH.</P><P></P><P>I think i might need to do a union ... but not sure how to go about it ?</P><P></P><P>Attached is a small example of the issue.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 21 Jun 2011 19:46:10 GMT 2011-06-21T19:46:10Z Combine 2 columns for filter .. union ? https://community.qlik.com/t5/QlikView/Combine-2-columns-for-filter-union/m-p/307844#M1192660 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P><STRONG>Problem: </STRONG> If every transaction has a buy &amp; a sell currency. I am aiming to return any row which has a particluar currency as either BUY or SELL or BOTH.</P><P></P><P>I think i might need to do a union ... but not sure how to go about it ?</P><P></P><P>Attached is a small example of the issue.</P><P></P><P>Thanks</P></BODY></HTML> Tue, 21 Jun 2011 19:46:10 GMT https://community.qlik.com/t5/QlikView/Combine-2-columns-for-filter-union/m-p/307844#M1192660 2011-06-21T19:46:10Z Re: Combine 2 columns for filter .. union ? https://community.qlik.com/t5/QlikView/Combine-2-columns-for-filter-union/m-p/307845#M1192666 <HTML><HEAD></HEAD><BODY><P>Hope this helps.</P></BODY></HTML> Tue, 21 Jun 2011 20:49:30 GMT https://community.qlik.com/t5/QlikView/Combine-2-columns-for-filter-union/m-p/307845#M1192666 danielrozental 2011-06-21T20:49:30Z Combine 2 columns for filter .. union ? https://community.qlik.com/t5/QlikView/Combine-2-columns-for-filter-union/m-p/307846#M1192671 <HTML><HEAD></HEAD><BODY><P>That worked.... Thanks !!</P></BODY></HTML> Tue, 21 Jun 2011 22:18:22 GMT https://community.qlik.com/t5/QlikView/Combine-2-columns-for-filter-union/m-p/307846#M1192671 2011-06-21T22:18:22Z