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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

want a count of Orders, but need to confirm the order type = O and order source = 'F'

=Count({$<VCOHead_ordertype = {'O'}, OrderSource = {'F'}, OrderSource = {'I'}>}[CustomerID])

want to count the number of customerID when the ordertype is equal to 'O' and the OrderSource is equal to 'F' or OrderSource is equal to 'I' how can I write this up in the expression tab. currently I only see the count for the order type of 'I'



1 Reply
Not applicable
Author

=

Count({$<VCOHead_ordertype = {'O'}, OrderSource = {'F','I','E','P'}}>}[CustomerID])

- this is what I used instead of breaking all the ordersource down into single. Merged the choices together..

close the request.