28889_en-US

liliconcom

Why do I get a chart IF no data ?

Hi,

 

Using the Big Class jmp table as example ( attached)

 

Running the script below where I use a local filter :sex == "C" , I know "C" is missing , so No data.

 

Why do I get a chart with "all data" ?

Which condition should I add to have, If No data, No chart created ?

 

Thanks

geof

 

 

 

Graph Builder(
 Variables( X( :sex ) ),
 Elements( Bar( X, Legend( 3 ) ) ),
 Local Data Filter( Add Filter( columns( :sex ), Where( :sex == "C" ) ) ),
 SendToReport( Dispatch( {}, "400", LegendBox, {Set Title( "" )} ) )
);

Re: Why do I get a chart IF no data ?

Thanks Jim

 

Re: Why do I get a chart IF no data ?

I assume the Local Data Filter is overridding what to it is an invalid Where clause.  To accomplish what you want, the below script will work:

Local Data Filter(
 Inverse( 1 ),
 Add Filter( columns( :sex ), Where( :sex == {"F", "M"} ) )
);