Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

Combining logical operators in set analysis

Hi,

I need to create a set analysis expression which as OR conditions and  AND condition(s).

in general it looks:

(Condition 1 OR Condition 2 OR Condition 3) AND Condition 4 AND Condition 5.

Any ideas how to accomplish this?

Thanks in Advance!

Dafnis

1 Solution

Accepted Solutions
tresesco
MVP
MVP

OR -> +

AND -> *


In general,

Sum({<Set1>+<Set2>} Amt)

Sum({<Set1>*<Set2>} Amt)

So for your case, might be like:

Sum({(<Condition 1> + <Condition 2> + <Condition 3>) * <Condition 4> * <Condition 5>} Field)

View solution in original post

5 Replies
tresesco
MVP
MVP

OR -> +

AND -> *


In general,

Sum({<Set1>+<Set2>} Amt)

Sum({<Set1>*<Set2>} Amt)

So for your case, might be like:

Sum({(<Condition 1> + <Condition 2> + <Condition 3>) * <Condition 4> * <Condition 5>} Field)

dafnis14
Specialist
Specialist
Author

Great! Thanks!

BTW, is it possible to use a variable for the above expression?

tresesco
MVP
MVP

Yes.

Not applicable

Is there a way to have current selection AND bookmark?

Say I have a bookmark called 'BASELINE'

I tried {BASELINE+1} but that does not appear to work.

Nor does {<BASELINE>+<1>}

Any other ideas?

tresesco
MVP
MVP

Current selection is referred by '$'. So try like:  {$+Bookmark}