topic Re: Function "bitand" in QlikView

Function "bitand"

Wed, 06 Oct 2010 13:46:57 GMT

Hey there!

Did anybody already use the function "bitand" successfully? The manual unfortunately doesn't contain an example for its usage .

I tried to use it this way: bitand(integer,integer). During execution of the script I get the following error:

Error in expression:

BITAND is not a valid function

Thank you in advance for your help.

Best regards

Chris

SV:Function "bitand"

frank_carlsson — Wed, 06 Oct 2010 13:59:30 GMT

I have used it like this:

Prodtr_lev:

Load

AcYrPr

as Avstämmningsperiod

Replace

(trim(upper(InvoRef)),' ','') as InvoRef

DAm

as DAm

OrdNo

SupNo

TransSt

ExcPrint

Num

(TransSt,'(bin)') as Transstatus

Num

(ProcMt,'(bin)') as Bitvalue1

Num

(ExcPrint,'(bin)') as Bitvalue2

Num

(EditPref,'(bin)') as Bitvalue3

Num

(EdFmt,'(bin)') as Bitvalue4

Num

(SpecFunc,'(bin)') as

Bitvalue5

;

SQL

SELECT *

FROM

$(Company)

.dbo.ProdTr

Where

TrTp = 6 and FinDt >= 20100501 and (SupNo <> 0 or SupNo = 1001);

//and OrdNo <> 1;// and Ctrl = 0;

Temp:

Noconcatenate

Load

(16384 Bitand Bitvalue2 = 16384,1,0) as Bv2

(16 Bitand Transstatus = 16,1,0) as

Trst

Resident

Prodtr_lev;

and in Where clause:

WHERE

OrdNo > 35600 AND TrTp = 1 AND applymap('mOrdTp',OrdNo) <= 4 And OrdLnSt bitand 8 = false() ;

SV:Function "bitand"

frank_carlsson — Wed, 06 Oct 2010 14:00:14 GMT

Wow, that looked really awful... hope you can read my example.

SV:Function "bitand"

Wed, 06 Oct 2010 14:52:24 GMT

thanks! It works 🙂

Re: SV:Function "bitand"

alexmosq — Fri, 01 Mar 2013 13:45:47 GMT

Thanks dude!

Re: Function "bitand"

rupalimane1390 — Wed, 16 Jun 2021 10:29:25 GMT

Thank you @frank_carlsson . i was struggling since a week to use BITAND expression of oracle in Qlik.

Thanks a ton for detailed code 🙂