COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Topic started by: nishanthini on 05 Jul 2012 03:55:52 AM

Title: Check if data is null
Post by: nishanthini on 05 Jul 2012 03:55:52 AM
Hi,

I have a requiremnt lik the below.

i have a column in a table which has few values and few null values.
I basically have to display chart2 when this particular column has only null value.

If it has any not null value then i have to show chart1.

How to set this condition in conditional explorer.
Title: Re: Check if data is null
Post by: CoolP on 05 Jul 2012 07:24:43 AM
Create a boolean variable with the condition [col1] is not null.


Assign this boolean variable as the render variable for the chart(s).




Thanks
Prasan