topic Set operation for multiple condition. in QlikView

Set operation for multiple condition.

Tue, 30 Jun 2015 11:46:41 GMT

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 — Tue, 30 Jun 2015 11:51:54 GMT

Try this:

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

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

jonathandienst — Tue, 30 Jun 2015 11:52:30 GMT

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

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

avinashelite — Tue, 30 Jun 2015 11:55:45 GMT

you can also try with if condition as well

buzzy996 — Tue, 30 Jun 2015 11:57:28 GMT

try with tis,

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

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