topic Re: How to hide the table when clearall in QlikView

How to hide the table when clearall

Anonymous — Thu, 26 Mar 2015 14:00:28 GMT

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 — Thu, 26 Mar 2015 14:05:51 GMT

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

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

Anonymous — Thu, 26 Mar 2015 15:51:01 GMT

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

Anonymous — Thu, 26 Mar 2015 15:51:56 GMT

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

awhitfield — Thu, 26 Mar 2015 16:08:29 GMT

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 — Thu, 26 Mar 2015 16:15:04 GMT

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 — Thu, 26 Mar 2015 16:22:23 GMT

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

Andy

yura_ratu — Thu, 26 Mar 2015 16:31:22 GMT

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

awhitfield — Thu, 26 Mar 2015 16:36:22 GMT

I can't see any!!

yura_ratu — Thu, 26 Mar 2015 16:39:34 GMT

just add some fields and it will be available

awhitfield — Thu, 26 Mar 2015 16:43:43 GMT

Ha ha - so there it is!

andy