Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

When writing an expression what is the format for multiple conditions?

For example, I want to count field C where A='X' AND B='Y'.

count({$<AExitState={Dropped}>}ACallDate)

Thank you,

Sarah

3 Replies
Anonymous
Not applicable
Author

Sarah,
If you prefer set analysis - use intersection (*): <condition A>*<condition B>.
Without set analysis, it will be if(<condition A> AND <condition B>, ...)

Not applicable
Author

Hi,

using set analysis, I think you could also write

count({$<A={X}, B={Y}>} C)

i dont know if there's a difference with intersection operator as suggested by Michael, though ...

Hilaire

Not applicable
Author

Thank you for your feedback! I ended up using:

count({$<A={'X'},B={'Y'}>}C)