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

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

Wed, 24 Mar 2010 18:10:03 GMT

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

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

Thank you,

Sarah

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

Anonymous — Wed, 24 Mar 2010 18:20:23 GMT

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

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

Wed, 24 Mar 2010 18:46:12 GMT

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

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

Wed, 24 Mar 2010 21:58:57 GMT

Thank you for your feedback! I ended up using:

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