Skip to main content

Bit operators

All bit operators convert (truncate) the operands to signed integers (32 bit) and return the result in the same way. All operations are performed bit by bit. If an operand cannot be interpreted as a number, the operation will return NULL.

Bit operators
Bit operator Operator name Operator function
bitnot Bit inverse

Unary operator. The operation returns the logical inverse of the operand performed bit by bit.

Example:  

bitnot 17 returns -18

bitand Bit and

The operation returns the logical AND of the operands performed bit by bit.

Example:  

17 bitand 7 returns 1

bitor Bit or

The operation returns the logical OR of the operands performed bit by bit.

Example:  

17 bitor 7 returns 23

bitxor Bit exclusive or

The operation returns the logical exclusive or of the operands performed bit by bit.

Example:  

17 bitxor 7 returns 22

>> Bit right shift

The operation returns the first operand shifted to the right. The number of steps is defined in the second operand.

Example:  

8 >> 2 returns 2

<< Bit left shift

The operation returns the first operand shifted to the left. The number of steps is defined in the second operand.

Example:  

8 << 2 returns 32

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com