Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld starts MONDAY! last chance to register is now ! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Sum multiple conditions

HI,

I want to sum, but my expression dont work.

Laboratory cold be: Bayt, Bayaten, etc

sum({<Or={'Target'},Laboratory={'Bay*'}>} total)

Labels (1)
1 Solution

Accepted Solutions
Or
Master
Master

Try double-quotes around your wildcard:

sum({<Or={'Target'},Laboratory={"Bay*"}>} total)

Also, you should really consider not naming your field "total", that is a keyword and can be quite confusing in this context.

View solution in original post

1 Reply
Or
Master
Master

Try double-quotes around your wildcard:

sum({<Or={'Target'},Laboratory={"Bay*"}>} total)

Also, you should really consider not naming your field "total", that is a keyword and can be quite confusing in this context.

View solution in original post