topic Show or Hide Panel on condition in QlikView

Show or Hide Panel on condition

Tue, 09 Jul 2013 09:16:03 GMT

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.

Re: Show or Hide Panel on condition

Gysbert_Wassenaar — Tue, 09 Jul 2013 10:08:48 GMT

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).