How to hide the table when clearall

[Anonymous]

Hi All,

I've bar chart with values based on priority like low,medium,high & critical.

Also have table box, its contains TC execution related data like tcid,tcname,executed by.

If I click the high mean table box will filter with high priority bugs. After that clear all the fiters ,table box also clear the filters.

What I want means once the clear the filter, table box should disappear. How can I do that?

when I apply filler then only it should appear with selected priority.

[Colin-Albert]

On the Layout tab of the chart properties , select Show, Conditional  and add this formula in the box

=if(GetCurrentSelections()>'',1,0)

[Anonymous]

I added in chart properties, even though table box not hide.

[Anonymous]

How can i link the table box with chart using this formula?

[awhitfield]

Hi Prakash,

you need to use a Straight table rather than a table box, see attached example, with

If(GetCurrentSelections()>'',1,0)

as The Show - Conditional value on the Layout tab of a straight table.

[yura_ratu]

Follow the advice of Collin, but make it for table box, if you want to hide table box. You don't need to hide a chart, if I get you right

[awhitfield]

You can't apply a conditional Show on a normal table box as there's no layout tab

Andy

[yura_ratu]

Hi Andrew. Are you sure? there is Layout tab and conditional showing in table box settings 

[awhitfield]

I can't see any!!

[yura_ratu]

just add some fields and it will be available