topic Re: How to hide/unhide table view based on another table view in Qlik in QlikView

How to hide/unhide table view based on another table view in Qlik

Mon, 26 Jan 2026 18:19:17 GMT

I have Straight table..which contain region,regioniD,amount.
when I click on region value of table1,another straight table (table2) appear below on table1.

But when i Click on Clear button table2 hide and table1 appear as full date

Re: How to hide/unhide table view based on another table view in Qlik

MK_QSL — Tue, 02 Sep 2014 08:58:39 GMT

Go to Properties of 2nd Table...

Layout tab

Show

Conditional

Type below

=GetSelectedCount(region)>0

Re: How to hide/unhide table view based on another table view in Qlik

sundarakumar — Tue, 02 Sep 2014 09:00:57 GMT

this might be bec they have set the table 2 to show only if there is a selection made in talbe one.

check for "condition" in layout tab. they would have specified a condition like

if(getselectedcount(region)=1,1,0)...

Straight table takes lot of time to load when we have huge data, so we go for these options to improve performance.

-Sundar

Re: How to hide/unhide table view based on another table view in Qlik

Tue, 02 Sep 2014 09:01:00 GMT

Check is auto max is selected?

Also if you give some more description with the attachement it would be good to help you

Re: How to hide/unhide table view based on another table view in Qlik

Tue, 02 Sep 2014 09:51:12 GMT

it is working,but ifI click on any dimension value (Like region,region ID) in both case table2 should be hide/unhide.

Re: How to hide/unhide table view based on another table view in Qlik

sundarakumar — Tue, 02 Sep 2014 11:00:28 GMT

change the condition to

if(getselectedcount(region)=1 or getselectedcount([region ID])=1,1,0)