Weird values calculated with XOR,AND in QlikView

Fri, 05 Mar 2010 09:16:55 GMT

Hello to all of you 😉

i've a quick question for you: i have to manage in the same formula different cases.
This formula uses XOR, AND.

i've noticed that, in QV,
1 AND 1 returns -1
1 XOR 0 returns -1.

Is that a bug ? Is there a way in the config to say to QV to return 1 instead?

Thanks a lot 😉

Weird values calculated with XOR,AND in QlikView

Fri, 05 Mar 2010 09:18:26 GMT

I just checked the QV Help and it's normal 😉


<h1>Logical operators</h1>
All logical operators interpret the operands logically and return true (-1) or false (0) as result. <table><tbody><tr><td>
not</td><td>
Logical inverse. One of the few unary operators. The operation returns the logical inverse of the operand. </td></tr><tr><td>
and</td><td>
Logical and. The operation returns the logical and of the operands. </td></tr><tr><td>
or</td><td>
Logical or. The operation returns the logical or of the operands. </td></tr><tr><td>
Xor</td><td>
Logical exclusive or. The operation returns the logical exclusive or of the operands. I.e. like logical or, but with the difference that the result is false if both operands are true. </td></tr></tbody></table>

Anyway, thanks a lot ^^

topic Weird values calculated with XOR,AND in QlikView in QlikView

Weird values calculated with XOR,AND in QlikView

Weird values calculated with XOR,AND in QlikView