topic Set analysis for OR Condition in QlikView

Set analysis for OR Condition

Thu, 19 Jan 2012 09:46:17 GMT

could any one help me how to use set analysis fot OR condition.

For Example,

Id subid amt

1 1 10

1 2 20

2 3 30

2 4 40

I can use sum(if(Id=1 or subid=3,amt))

how to use the above expression in set analysis.

thanks in advance.

Thu, 19 Jan 2012 10:12:32 GMT

hi,

you can try it

=sum({$<Id={"1"}>} amt)+sum({$<subid={"3"}>} amt)

srinivasa1 — Thu, 19 Jan 2012 10:13:49 GMT

Hi try this one.

sum( {$<id= {1},subid={3} >} amt ).

enjoye..

IAMDV — Thu, 19 Jan 2012 10:14:01 GMT

Here is what you need to use...

sum({<Id={1}>+<subid={3}> amt)

"+" is the binary union set operator.

I hope this helps!

Cheers - DV

nstefaniuk — Thu, 19 Jan 2012 10:15:48 GMT

sum({ ($<Id={1}>+$<subid={3}>)}amt)

Thu, 19 Jan 2012 10:16:33 GMT

hi,

I think your answer is more correct

IAMDV — Thu, 19 Jan 2012 10:18:00 GMT

Also I'm attaching a Set Analysis presentation for you reference. Please read the Set Operators topic in the presentation for full understanding.

Good luck!

Cheers - DV