topic Re: BITXOR function in QlikView

BITXOR function

Anonymous — Tue, 06 Jan 2015 11:31:36 GMT

Specialsts,

How can I use the the function BITXOR in a Qlikview load script?

BITXOR function

I would like the result to be the same as in EXCEL : BITXOR(number1, number2)

Is that possible?

Thanks,

Dennis.

Re: BITXOR function

marcus_malinow — Tue, 06 Jan 2015 15:06:26 GMT

Hi Dennis,

bitxor (and other bitwise operators) are all in the documentation so I imagine it's as simple as

bitxor(number1, number2)

The script editor may indicate an error but the script should still load.

Marcus

Re: BITXOR function

Anonymous — Tue, 06 Jan 2015 15:31:50 GMT

Thanks Marcus,

But I seems like it doesn't work.

It returns:

Error in expression:

BITXOR is not a valid function

Berekening:

LOAD *,

bitxor(num, num2) as Bin_num

Re: BITXOR function

Anonymous — Tue, 06 Jan 2015 15:33:10 GMT

I fixed it by creating a VB-function in the Module Editor.

And use that function in the script.

Thanks for your time.

Dennis.

Re: BITXOR function

MarcoWedel — Tue, 06 Jan 2015 16:36:01 GMT

Hi,

bitxor being an operator and not a function, another more straightforward approach could be:

LOAD *,

OP1 bitxor OP2 as OP1xorOP2

Inline [

OP1, OP2

0, 1

1, 0

1, 1

2, 0

2, 1

2, 2

255, 1

255, 2

255, 4

255, 8

255, 16

255, 32

255, 64

255, 128

];

hope this helps

regards

Marco

Re: BITXOR function

MarcoWedel — Wed, 07 Jan 2015 00:07:38 GMT

to improve readability:

hope this helps

regards

Marco