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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
danieldors
Contributor III
Contributor III

Count Multiple Criterias

Hello,

Im trying to add a second criteria to the count below with no success. I need to count reviewid which errorcode <>Yes and critical=Yes.

(Count({<reviewId={"=errorCode<>YES"}>}distinct [reviewId]))

{"=critical=YES"}

Thank you.

1 Solution

Accepted Solutions
Vegar
MVP
MVP

I believe this is what you are trying to do. 

Count({<errorCode-={'YES'},critical={'YES'} >}distinct [reviewId])

 

View solution in original post

2 Replies
Vegar
MVP
MVP

I believe this is what you are trying to do. 

Count({<errorCode-={'YES'},critical={'YES'} >}distinct [reviewId])

 

danieldors
Contributor III
Contributor III
Author

Thank you. It worked well.