New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for
Did you mean:
Highlighted
Contributor III

Problem on expression with "or"

Hello all,

I have a problem on an expression today.

I try to chart data where I want the sum of C when field A or B = 1.

I tried the following :

Sum({\$<A={1} or B={1}>}C)

But it always tells me there is an error...

Any idea ?

Labels (3)

• or operator

2 Solutions

Accepted Solutions
Highlighted
MVP

Try this

``Sum({<A = {1}>+<B = {1}>} C)``
Highlighted
MVP

Within set analysis

* = AND

+ = OR

5 Replies
Partner

Sum({\$<A={1}>*<B={1}>}C)

Regards

Highlighted
MVP

Try this

``Sum({<A = {1}>+<B = {1}>} C)``
Highlighted
Contributor III

thanks a lot for your help but it seems this expression sends me a result when A AND B are equal to 1.

Nevertheless thanks a lot 🙂

Highlighted
Contributor III
Thanks a lot ! to be honest I didn't really understand the "Logic" but the result seems to be the right one...
As i don't see the "Or" operande I don't know how it can understand that I want results where A OR B = 1 ... This expression to me would have meant A AND B = 1, but it is working, so thanks a lot to you !!!
Highlighted
MVP

Within set analysis

* = AND

+ = OR