Weird values calculated with XOR,AND in QlikView

[#1]

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 😉

[#2 · Accepted solution]

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 ^^