IBM Business Analytics

Hello everyone,

I am trying to figure out a way to filter my data in such a way that I can have a list of products that do not contain a certain criteria. In my example I want to only display the Refrigerators that are not available in purple color. So I want all the Refrigerators that come in purple to be filtered out. Currently when I attempt to filter the Purple color it just does not display Purple in the table but shows the Beta Refrigerator along with the other 4 color options. I want the Beta Refrigerator to be removed from the table based on it being available in Purple.

I hope this makes sense and thank you for any help!

Cognos 11.2.2

------------------------------
Markis Lawson
------------------------------

Hello @Markis Lawson,

>>I want the Beta Refrigerator to be removed from the table based on it being available in Purple.

You need to combine product and color in a query element and filter against the color:

This will provide combinations that you want to filter out based on the color:

Then create a second query where Product+Color not in Query1.Product+Color:

Which then will provide all products that not of the desired color:

Hope this helps.

Regards,

Ralf