Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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)

View solution in original post

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}