Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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 ?

2 Solutions

Accepted Solutions
Highlighted

Re: Problem on expression with "or"

Try this

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

View solution in original post

Highlighted

Re: Problem on expression with "or"

Within set analysis

* = AND

+ = OR

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: Problem on expression with "or"

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

Regards

Highlighted

Re: Problem on expression with "or"

Try this

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

View solution in original post

Highlighted
Contributor III
Contributor III

Re: Problem on expression with "or"

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
Contributor III

Re: Problem on expression with "or"

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

Re: Problem on expression with "or"

Within set analysis

* = AND

+ = OR

View solution in original post