Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
mpfarrer
Contributor
Contributor

Permanent Filter in Chart

I have a table that I would like to permanently sort.  Right now the table shows all employees in column A and the count of how many orders they have done in column B.  I want to filter out everyone who has not completed an order and show anyone who has completed greater than zero.  I have tried to use Count({<OrderStatus>{0}>}OrderStatus); however, it is giving me an error: '}' expected.

1 Reply
Lisa_P
Employee
Employee

Correct syntax for set analysis would be:

Count({<OrderStatus={">0"}>}OrderStatus)