Radio buttons and excludes filter

[thart21]

I am trying to use two radio buttons 'Yes' and 'No' to use as a filter. Have tried a CASE WHEN statement but cannot seem to get the <> part correct. Getting an error at the "not in" part.

CASE WHEN(?Golf? = 'No')  THEN([Presentation Layer].[Regional Product].[Cat Cd (Sls Org)] not in ('000233')
ELSE... show all Cat Cds

END

Thanks for any help you could give,

Toni

[blom0344]

How about:

Code Select Expand


CASE WHEN(?Golf? = 'No')  THEN([Presentation Layer].[Regional Product].[Cat Cd (Sls Org)] <> '000233'
ELSE 1 = 1 END


[CognosPaul]

How about setting the static value of the prompt object to:

Display | Use
----------------------
No       |  [Presentation Layer].[Regional Product].[Cat Cd (Sls Org)] <> '000233'
Yes      | 1=1

Set the default value to one of those. And your filter should be a simple
#prompt('Golf','token')#

[thart21]

Thanks so much for the replies, I used the static values option and set the default values in my prompts, very cool!  I will be using the CASE statement a lot as well. 

Thanks again, new to Cognos and love the forum!

Toni