topic Sum with multiple conditions in QlikView

Sum with multiple conditions

aria_123 — Sat, 16 Nov 2024 21:13:53 GMT

How do I sum based on multiple conditions?

I only want the approved and pending Status sum cost from Type=issue.

Type == Issue AND (Status != "Rejected" OR Status !="Rejected")

=Round (Sum ({<Type={'Issues'}, Status -={'Rejected'} , Status -={'Canceled'}>} [Cost Ratio]), 0.01)

But with this, I keep getting the "Rejected" ones. It does exclude the "Canceled" items.

Re: Sum with multiple conditions

Vegar — Fri, 15 Mar 2019 18:16:01 GMT

Try this expression:
=Round (Sum ({<Type={'Issues'}, Status -={'Rejected','Canceled'}>} [Cost Ratio]), 0.01)

Re: Sum with multiple conditions

jonnaamb — Fri, 15 Mar 2019 18:59:00 GMT

Hello Aria,

The same modifier cannot be given twice in one expression. When you give 'Status' twice, it is considering the second 'Status' as null. I've attached a screenshot as to how Set Analysis can be remembered easily.

The ideal expression would be this:

=Round (Sum ({<Type={'Issues'}, Status -={'Rejected','Canceled'}>} [Cost Ratio]), 0.01)

Best regards,

Ambareesh

Re: Sum with multiple conditions

aria_123 — Fri, 15 Mar 2019 21:36:18 GMT

Wow. Thanks for quick responses. It works!