Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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)