topic Re: Set analysis check for equality between fields in QlikView

Set analysis check for equality between fields

Wed, 26 Nov 2014 09:57:28 GMT

Hello,

I am trying to check for field1 = field2 and compute sum(filed3) in set analysis expression.

Ex:

Field1 Field2 Field3

01 01 1

02 01 1

02 02 1

if, '01' of Field1 is selected, then the result shoud be 1,

if '02' of Field2 is selecetd, then the result shuld be 2.

Please help me

Thanks,

Deepa

Re: Set analysis check for equality between fields

alexandros17 — Wed, 26 Nov 2014 10:00:00 GMT

In set analysis you cannot compare a field with another field but only a field with a value (this can be the max, sum, aggr ... of another field but not the whole field)

Hope it helps

Re: Set analysis check for equality between fields

Wed, 26 Nov 2014 10:06:02 GMT

You mean, we cannot compare the value of Fieid1 with value of Fields2

as we do in IF(Field1 = Field2,Sum(Field3))