https://community.qlik.com/t5/Search-the-Community/Permanent-Filter-in-Chart/m-p/1836514#M553 <P>Correct syntax for set analysis would be:</P><P><SPAN>Count({&lt;OrderStatus={"&gt;0"}&gt;}OrderStatus)</SPAN></P> Wed, 15 Sep 2021 23:46:53 GMT Lisa_P 2021-09-15T23:46:53Z https://community.qlik.com/t5/Search-the-Community/Permanent-Filter-in-Chart/m-p/1836478#M552 <P>I have a table that I would like to permanently sort. &nbsp;Right now the table shows all employees in column A and the count of how many orders they have done in column B. &nbsp;I want to filter out everyone who has not completed an order and show anyone who has completed greater than zero. &nbsp;I have tried to use Count({&lt;OrderStatus&gt;{0}&gt;}OrderStatus); however, it is giving me an error: '}' expected.</P> Wed, 15 Sep 2021 19:40:19 GMT https://community.qlik.com/t5/Search-the-Community/Permanent-Filter-in-Chart/m-p/1836478#M552 mpfarrer 2021-09-15T19:40:19Z https://community.qlik.com/t5/Search-the-Community/Permanent-Filter-in-Chart/m-p/1836514#M553 <P>Correct syntax for set analysis would be:</P><P><SPAN>Count({&lt;OrderStatus={"&gt;0"}&gt;}OrderStatus)</SPAN></P> Wed, 15 Sep 2021 23:46:53 GMT https://community.qlik.com/t5/Search-the-Community/Permanent-Filter-in-Chart/m-p/1836514#M553 Lisa_P 2021-09-15T23:46:53Z