topic Dimension Filtering in QlikView https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990916#M337659 <HTML><HEAD></HEAD><BODY><P>I'm wanting to filter out the accounts that do not have 840 External_Trans_Code, but have more than 3 transactions that are External_Trans_Code 137, 145, and/or 146. Thanks</P></BODY></HTML> Thu, 29 Oct 2015 13:51:21 GMT mapratt82 2015-10-29T13:51:21Z Dimension Filtering https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990916#M337659 <HTML><HEAD></HEAD><BODY><P>I'm wanting to filter out the accounts that do not have 840 External_Trans_Code, but have more than 3 transactions that are External_Trans_Code 137, 145, and/or 146. Thanks</P></BODY></HTML> Thu, 29 Oct 2015 13:51:21 GMT https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990916#M337659 mapratt82 2015-10-29T13:51:21Z Re: Dimension Filtering https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990917#M337660 <HTML><HEAD></HEAD><BODY><P>Use an if expression or set analysis.</P></BODY></HTML> Thu, 29 Oct 2015 15:38:21 GMT https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990917#M337660 jduarte12 2015-10-29T15:38:21Z Re: Dimension Filtering https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990918#M337661 <HTML><HEAD></HEAD><BODY><P>Why not using two bookmarks and/or a conditional search?</P></BODY></HTML> Thu, 29 Oct 2015 15:39:28 GMT https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990918#M337661 miguelbraga 2015-10-29T15:39:28Z Re: Dimension Filtering https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990919#M337662 <HTML><HEAD></HEAD><BODY><P>You can filter this by using a WHERE clause in the script after LOAD if you don't want permanently those values. If you want to filter in a Listbox, please read my sugestion above. If you're want to filter in a expression please follow João Nuno Duarte's sugestion <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P></BODY></HTML> Thu, 29 Oct 2015 15:43:03 GMT https://community.qlik.com/t5/QlikView/Dimension-Filtering/m-p/990919#M337662 miguelbraga 2015-10-29T15:43:03Z