Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
prakash743
New Contributor III

How to hide the table when clearall

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.

10 Replies
Highlighted

Re: How to hide the table when clearall

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

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


Highlighted
prakash743
New Contributor III

Re: How to hide the table when clearall

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

Highlighted
prakash743
New Contributor III

Re: How to hide the table when clearall

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

Highlighted
Partner
Partner

Re: How to hide the table when clearall

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.

Highlighted
Partner
Partner

Re: How to hide the table when clearall

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

Highlighted
Partner
Partner

Re: How to hide the table when clearall

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

Andy

Highlighted
Partner
Partner

Re: How to hide the table when clearall

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

Highlighted
Partner
Partner

Re: How to hide the table when clearall

I can't see any!!

tablebox.png

Highlighted
Partner
Partner

Re: How to hide the table when clearall

just add some fields and it will be available