Suppress when value is null does not affect other objects in associative way

[Anonymous]

Hi everybody,

I'm facing the followin problem:

• One straight table showing customer orders, rows suppressed when actual shipment date is null (in order to show only shipped orders)
• One list box showing customer codes
• Customer codes suppressed in straight table (i.e.: all the orders of a customer are not shipped) are still shown in list box as options

Is there any way to overcome this and suppress values in other objects associatively linked to the main one?

Thanks.

Giuseppe

[Gysbert_Wassenaar]

Objects are not linked associatively. The data in the internal tables is. The only way to suppress null values document wide is to remove them in the script so there are no null values at all. That's not always possible since missing values are also treated as nulls. See this blog post: The Importance of Nothing

[Anonymous]

Thank you for your comment Gysbert,

you're totally right about, I did not express my self in a proper way.

Unfortunately I cannot apply your suggestion since my document serves to multiple purposes (removing combinations of data that lead to null value would restrict other analysis' scope)

Any other way to achieve the result?

Thanks.

Giuseppe.

[Gysbert_Wassenaar]

Sure, apply the Suppress when Null setting to all chart objects manually.

[swuehl]

As Gysbert said, the charts are only linked by the available data to each other, i.e. selections in one will be reflected in each other (assuming not using set analysis, alternate states etc.. just plain default mode).

If you suppress dimension values in a chart by making use conditions etc. you would need to apply a similar logic to the other charts if you expect to see the same dimension / field values only.

For a list box, you can use a field expression (select <expression> from the field drop down list), then use something like

=if( len(trim(ShippedDate)), Customer)

or what ever works for a calculated dimension to show the customers you want to show.