Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Show or Hide Panel on condition

HI I want to be able to show or hide a text box on a ListBox Condition.  If one item is selected or if there are no items in the listbox then I need to hide a text box.

My 'Layout' condition is : 

count(DISTINCT [Test Group])<>1

or COUNT(DISTINCT [Test Group])>0

It works when I test on one condition but not when I try and do both.

Any help is appreciated.

Many thanks.

1 Reply

Well, if you combine the two with an OR the result will always be true.

  • count(DISTINCT [Test Group])<>1: 0 is not 1 so 0 returns true
  • or COUNT(DISTINCT [Test Group])>0: 1 is larger than zero so 1 return true

Anything larger than 1 will return true for both conditions so also always returns true.

What I think you want is if(getselectedcount([Test Group]) > 1, 1, 0).

talk is cheap, supply exceeds demand