https://community.qlik.com/t5/QlikView/Straight-Table-Data-Filter-Issue/m-p/1624109#M733951 <P>Sum({&lt;Category-={'TV'}&gt;}Sales)</P> Mon, 16 Sep 2019 10:22:16 GMT miskinmaz 2019-09-16T10:22:16Z https://community.qlik.com/t5/QlikView/Straight-Table-Data-Filter-Issue/m-p/1624107#M733950 <P>I have a Straight table /dataset as below</P><TABLE><TBODY><TR><TD>SalesRep</TD><TD>Category</TD><TD>Sum(Sales)</TD></TR><TR><TD>A</TD><TD>TV</TD><TD>100</TD></TR><TR><TD>A</TD><TD>Laptop</TD><TD>200</TD></TR><TR><TD>B</TD><TD>Laptop</TD><TD>300</TD></TR><TR><TD>B</TD><TD>Desktop</TD><TD>500</TD></TR><TR><TD>C</TD><TD>Laptop</TD><TD>450</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Since the sales Rep 'A' Sold the Category TV ,I want to exclude Sales Rep 'A' from the chart/Sheet.</P><P>&nbsp;</P><P>The result should be as follows</P><TABLE><TBODY><TR><TD>SalesRep</TD><TD>Category</TD><TD>Sum(Sales)</TD></TR><TR><TD>B</TD><TD>Laptop</TD><TD>300</TD></TR><TR><TD>B</TD><TD>Desktop</TD><TD>500</TD></TR><TR><TD>C</TD><TD>Laptop</TD><TD>450</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Please help</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Data-Filter-Issue/m-p/1624107#M733950 250575qlik 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Straight-Table-Data-Filter-Issue/m-p/1624109#M733951 <P>Sum({&lt;Category-={'TV'}&gt;}Sales)</P> Mon, 16 Sep 2019 10:22:16 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Data-Filter-Issue/m-p/1624109#M733951 miskinmaz 2019-09-16T10:22:16Z https://community.qlik.com/t5/QlikView/Straight-Table-Data-Filter-Issue/m-p/1624115#M733952 <P><span class="lia-inline-image-display-wrapper" image-alt="clipboard_image_0.png" style="width: 657px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/19258i40B39DC8C449EEF8/image-size/large?v=v2&amp;px=999" role="button" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></span></P><P>You need to use&nbsp; SET and E() to exclude the TV selling agents. (See attached QVW)</P><P><FONT face="courier new,courier"><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/19258i40B39DC8C449EEF8/image-size/large?v=1.0&amp;px=-1" border="0" width="657" height="100" title="clipboard_image_0.png" alt="clipboard_image_0.png" /></FONT></P><P><FONT face="courier new,courier">sum({&lt;SalesRep = E({&lt;Category={'TV'}&gt;}) &gt;} Sales)</FONT></P><P>&nbsp;</P> Mon, 16 Sep 2019 10:28:31 GMT https://community.qlik.com/t5/QlikView/Straight-Table-Data-Filter-Issue/m-p/1624115#M733952 Vegar 2019-09-16T10:28:31Z