COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ratnalein on 04 Jul 2013 11:07:59 AM

Title: the operator <>
Post by: ratnalein on 04 Jul 2013 11:07:59 AM
Hallo everyone,

I succeded to use create a filter with this definition:

[Filter Element] <> '1'


It just means, without the value 1.

I tried this, it didnt work:

[Filter Element] <> ('1';'2';'3')


I want to use <> for multiple values.  How can I do this?  Thank you for the advice.

Regards,

Ratna :)

Title: Re: the operator <>
Post by: barrysaab on 04 Jul 2013 11:29:56 AM
Try this:

[Filter Element] <> ('1','2','3')
Title: Re: the operator <>
Post by: blom0344 on 04 Jul 2013 03:15:06 PM
'not in' would better suit your needs..