topic Re: Apply filter on Table only in QlikView https://community.qlik.com/t5/QlikView/Apply-filter-on-Table-only/m-p/1587#M230 <HTML><HEAD></HEAD><BODY><P>May be use a set analysis like this</P><P></P><P><STRONG>Sum({&lt;[Transaction_ID] = {"=Sum(Sales) &gt; 1000"}&gt;}Sales)</STRONG></P></BODY></HTML> Tue, 16 Jan 2018 18:40:26 GMT sunny_talwar 2018-01-16T18:40:26Z Apply filter on Table only https://community.qlik.com/t5/QlikView/Apply-filter-on-Table-only/m-p/1586#M229 <HTML><HEAD></HEAD><BODY><P>I have a data set containing Sales by date and transaction #.</P><P></P><P>I want to build a table containing only sales which is over $1000. How can I add a filter to show only transactions with sales over $1000?</P><P></P><P>Please help.</P><P></P><P>Thanks,</P><P>Amit</P></BODY></HTML> Tue, 16 Jan 2018 18:36:32 GMT https://community.qlik.com/t5/QlikView/Apply-filter-on-Table-only/m-p/1586#M229 Anonymous 2018-01-16T18:36:32Z Re: Apply filter on Table only https://community.qlik.com/t5/QlikView/Apply-filter-on-Table-only/m-p/1587#M230 <HTML><HEAD></HEAD><BODY><P>May be use a set analysis like this</P><P></P><P><STRONG>Sum({&lt;[Transaction_ID] = {"=Sum(Sales) &gt; 1000"}&gt;}Sales)</STRONG></P></BODY></HTML> Tue, 16 Jan 2018 18:40:26 GMT https://community.qlik.com/t5/QlikView/Apply-filter-on-Table-only/m-p/1587#M230 sunny_talwar 2018-01-16T18:40:26Z Re: Apply filter on Table only https://community.qlik.com/t5/QlikView/Apply-filter-on-Table-only/m-p/1588#M231 <HTML><HEAD></HEAD><BODY><P>Thank you.. that did the trick!</P></BODY></HTML> Tue, 16 Jan 2018 20:13:03 GMT https://community.qlik.com/t5/QlikView/Apply-filter-on-Table-only/m-p/1588#M231 Anonymous 2018-01-16T20:13:03Z