topic BITAND... in QlikView

BITAND...

Tue, 09 Sep 2014 14:00:06 GMT

In SET analysis, can I use BITAND like this or is my syntax wrong? In the example below the Project Status is an integer value which can be 1,2,4,8,16,32 or 64

SUM({<ProjectStatus BITAND 48 >= {"48"}>}METRIC_COMPLETED)

Thanks in advance...

Syd

Re: BITAND...

JonnyPoole — Tue, 09 Sep 2014 14:08:38 GMT

I don't believe so , but i'm not sure which values (1,2,4,8,16,32,64) you expect to bring back from this SET expression. Can you elaborate what the intended filter would result in ?

Re: BITAND...

Gysbert_Wassenaar — Tue, 09 Sep 2014 14:15:13 GMT

No, only a field name can be used on the left hand side. You'd have to use something like this instead:

SUM({<ProjectStatus= {"=ProjectStatus BITAND 48 >= 48"}>}METRIC_COMPLETED)