topic Re: Combining logical operators in set analysis in QlikView

Combining logical operators in set analysis

dafnis14 — Thu, 03 Jul 2014 08:44:07 GMT

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

tresB — Thu, 03 Jul 2014 08:49:22 GMT

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 — Thu, 03 Jul 2014 09:09:10 GMT

Great! Thanks!

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

tresB — Thu, 03 Jul 2014 09:10:14 GMT

Yes.

Fri, 28 Oct 2016 12:42:53 GMT

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?

tresB — Fri, 28 Oct 2016 16:58:43 GMT

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