topic Question to bit flag in QlikView

Question to bit flag

qlikconsultant — Mon, 26 Jan 2026 18:19:17 GMT

Hi,

i have the following SQL Code:

mySQL:

SELECT unique

FROM table1

WHERE (bitflag& 64) >> 6 = 1)

In the QlikView I want a flag:

Table:

Load unique,

if(si_flags & 64 >> 6=1, 'bitflag64', 'no bitflag64') as myflag;

SQL

Load *

from table1;

But I get not the same result.

stabben23 — Mon, 25 Jun 2018 07:14:33 GMT

Hi Marcus,

maybe you should try to "encapsulate" the Field?

if("si_flags & 64 >> 6"=1, 'bitflag64', 'no bitflag64') as myflag;

qlikconsultant — Mon, 25 Jun 2018 07:46:51 GMT

I tried ", ' and (. All do not work.

qlikconsultant — Mon, 25 Jun 2018 07:55:25 GMT

It seems that this is the solution:

if((si_flags >> 6 )=1, 'bitflag64', 'no bitflag64') as myflag;