If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Check if data is null

Started by nishanthini, 05 Jul 2012 03:55:52 AM

Previous topic - Next topic

nishanthini

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.

CoolP

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
CoolP
Aspiring BI/Cognos Professional