topic Order of operations for logical operators? in QlikView

Order of operations for logical operators?

Anonymous — Fri, 09 Dec 2011 20:03:07 GMT

For the logical operators (and, or, not, xor), what is the order of operations?

For example, if I say

condition1 or condition2 and condition3

Will it evaluate as

(condition1 or condition2) and condition3

condition1 or (condition2 and condition3)

Also, is it possible to use parentheses to change that behavior?

Re: Order of operations for logical operators?

johnw — Fri, 09 Dec 2011 20:25:27 GMT

While I don't see it in the documentation, I would expect QlikView to implement the "standard" order of operations. In other words (and I'm sure I'm missing some, and might have something wrong):

terms inside parentheses
multiplication and division
addition and subtraction
comparisons
not
and
or
assignment
left to right

This should also answer your question about parentheses. Yes, you can override with parentheses because they come first in the order of operations.

But why even ask when you can so easily test? Type some expressions in and see what happens.

Re: Order of operations for logical operators?

Ken_T — Thu, 23 May 2024 13:40:01 GMT

I think, one of the big purposes of a community is to document the stuff not documented, so thousands of people don't all have to waste time testing to trial and error how something works