Trying to filter out groups and intersections between groups

[#1]

I'm trying to filter out our VOD content rights. I have TVOD, SVOD and Others. But some of our movies are both TVOD and SVOD. How do I make that? Now I can find the ones that are both TVOD&SVOD but they are not showing up as TVOD separated or SVOD separated.

if(("New_denmark_rights_SVOD" < 0 AND "New_denmark_rights_TVOD" < 0) OR ("New_finland_rights_SVOD" < 0 AND "New_finland_rights_TVOD" < 0) OR ("New_norway_rights_SVOD" < 0 AND "New_norway_rights_TVOD" < 0) OR ("New_sweden_rights_SVOD" < 0 AND "New_sweden_rights_TVOD" < 0), 'SVOD&TVOD',
 if("New_denmark_rights_SVOD" < 0 OR "New_finland_rights_SVOD" < 0 OR "New_norway_rights_SVOD" < 0 OR "New_sweden_rights_SVOD" < 0, 'SVOD',
 if("New_denmark_rights_TVOD" < 0 OR "New_finland_rights_TVOD" < 0 OR "New_norway_rights_TVOD" < 0 OR "New_sweden_rights_TVOD" < 0, 'TVOD', 'Other'))) as Product

Is there another way to do it? I'm having all the rights in our DB.

[maneshkhottcpl]

HI,

Can u share ur sample application or some examples so i can help u.

[#3]

What do you need to see?

[johnw]

So... rather than have it show up as Product = 'SVOD&TVOD', you would like it to show up if Product = 'SVOD' is selected OR if Product = 'TVOD' is selected? For that, you'd want two rows, one with Product = 'SVOD' and one with Product = 'TVOD'. Assuming you have an ID field on the original table, you could make a new table to store the products:

ID, Product
SVOD Movie #1, SVOD
TVOD Movie #2, TVOD
SVOD&TVOD Movie #3, SVOD
SVOD&TVOD Movie #3, TVOD

No idea if I'm understanding, though.