COGNOiSe.com - The IBM Cognos Community

I am having category prompt on Status data item . users want to select 'abc' Status   for one category and which is not equal to 'abc' another category  and last one is display both ,

Please help me

Quote from: PrawinM on 07 Mar 2018 09:50:38 AM
I am having category prompt on Status data item . users want to select 'abc' Status   for one category and which is not equal to 'abc' another category  and last one is display both ,

Please help me

Hi,

Sounds like your filter expression needs to be in the form

([Category] = 'One category' and [Status] = ?Your prompt parameter?) OR ([Category] = 'Another category' and [Status] <> ?Your prompt parameter?)

MF.

i didn't get you Am explaining in Detail with attached excel please help me


Thanks in Advance ,
P.K

Quote from: PrawinM on 07 Mar 2018 05:01:15 PM
i didn't get you Am explaining in Detail with attached excel please help me


Thanks in Advance ,
P.K

Hi,

It's not clear what you want to achieve - at least to me. Where are the value prompt values coming from? Are they manually entered? Are you looking to filter your result set based on the selected prompt value?

MF.

Sorry for that its my bad.let me explain clearly

in a value prompt i want static choices as a,b,c of acolumn name is 'xyz'

'xyz' has data of 01,02,03,04,05,06

Condition's

a = 06
b <> 06
c display both


its like a gender prompt


Thanks in advance.
P.K

Quote from: PrawinM on 09 Mar 2018 03:36:29 PM
Sorry for that its my bad.let me explain clearly

in a value prompt i want static choices as a,b,c of acolumn name is 'xyz'

'xyz' has data of 01,02,03,04,05,06

Condition's

a = 06
b <> 06
c display both


its like a gender prompt


Thanks in advance.
P.K

Hi,

In that case, you would need a filter expression that uses this approach:

([xyz] = '06' and 'a' = ?Your prompt parameter?) OR ([xyz] <> '06' and 'b' = ?Your prompt parameter?) OR ('c'  = ?Your prompt parameter?)

Cheers!

MF.