https://community.qlik.com/t5/Data-Quality/Defining-AND-clause-in-Business-Rule/m-p/2284050#M3884 Hi there,<BR />I was wondering whether it was possible to define AND clauses when defining business rules in Data Quality. For example, I wish to know in a table how many rows are from 'UK' by the country column and of those how many have a invoice greater than £5000.<BR />I tried defining in the business rule like Country = 'UK' and Invoice &gt; 5000 but I don't think this works or gives me the correct answer. Also, I tried setting these two rules separately but I think it just gives me how many rows are UK then it gives me (regardless of country) how many rows have invoice greater than 5000.<BR />How can I use the AND rule?<BR />Thanks,<BR />Facoda Fri, 22 Aug 2014 09:26:30 GMT Anonymous 2014-08-22T09:26:30Z https://community.qlik.com/t5/Data-Quality/Defining-AND-clause-in-Business-Rule/m-p/2284050#M3884 Hi there,<BR />I was wondering whether it was possible to define AND clauses when defining business rules in Data Quality. For example, I wish to know in a table how many rows are from 'UK' by the country column and of those how many have a invoice greater than £5000.<BR />I tried defining in the business rule like Country = 'UK' and Invoice &gt; 5000 but I don't think this works or gives me the correct answer. Also, I tried setting these two rules separately but I think it just gives me how many rows are UK then it gives me (regardless of country) how many rows have invoice greater than 5000.<BR />How can I use the AND rule?<BR />Thanks,<BR />Facoda Fri, 22 Aug 2014 09:26:30 GMT https://community.qlik.com/t5/Data-Quality/Defining-AND-clause-in-Business-Rule/m-p/2284050#M3884 Anonymous 2014-08-22T09:26:30Z https://community.qlik.com/t5/Data-Quality/Defining-AND-clause-in-Business-Rule/m-p/2284051#M3885 Hi All,&nbsp; <BR />Ok I think I found a solution to my problem. The answer is to use a filter in the table analysis section and then apply the business rules. <BR />But does anyone know how to write the filter expressions? Are they the same as SQL? For example if I write in the expression in the where filter like: Country = 'UK-England' AND 'UK-Scotland' it doesn't work but if I write: Country IN ('UK-England','UK-Scotland') it works. <BR />Is there a reference Talend on how to write the expressions? <BR />Thanks, <BR />Facoda Mon, 01 Sep 2014 11:50:29 GMT https://community.qlik.com/t5/Data-Quality/Defining-AND-clause-in-Business-Rule/m-p/2284051#M3885 Anonymous 2014-09-01T11:50:29Z