Question to bit flag

[qlikconsultant]

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]

Hi Marcus,

maybe you should try to "encapsulate" the Field?

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

[qlikconsultant]

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

[qlikconsultant]

It seems that this is the solution:

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