Selecting IDs restricted to certain parameters

[#1]

Hello,

I have a table something like this

ID          Parameter

1               A

1               B

1               C

2               A

2               B

3               A

3               C

4               B

4               C

4               D

Now I want to write a script that only gives me IDs that have either A or B and C so I want only ID 1 and 3 returned and not 2 and 4. I tried set analysis with something like

{<Parameter={'A','B'},Parameter={'C'}>} but I am also getting back 4 which I don't want because it also has D.

Can someone help me on this?

thanks,

Manoj

[swuehl]

Sunny, this looks good, should also work fine.

[sunny_talwar]

I am just curious how do you do all of this in your head? I mean I see you come up with solutions to thing which I might not even figure even if I had sample for. You are truly a genius and my QlikView role model