Set operation for multiple condition.

[#1]

Hi.

I have to select data from following sample data.

code1  code2  val1  val2

a         b           11    22

a         c           33    44

a         d           55    66

1         2           77    88

1         3           99    100

1         4           10    20

the conditions are  (code1 is a  and code 2 is d)  or  (code1 is 1 and code2 is 3).

please show me the way to get the data above conditions.

[sunny_talwar]

Try this:

{<code1 = {'a'}, code2 = {'d'}>}+{<code1 = {1}, code2 = {3}>}

{<code1 = {'a'}, code2 = {'d'}>+<code1 = {1}, code2 = {3}>}

[jonathandienst]

If you mean in a front end expression, then like this:

     {<code1 = {'a'}, code2 = {'d'}>+<code1 = {1}, code2 = {3}>}

[avinashelite]

you can also try with if condition as well

[buzzy996]

try with tis,

=sum({<code1={'a','1'},code2={'d','3'}>}val1)

=sum({<code1={'a','1'},code2={'d','3'}>}val2)