Hide List Box

[aveeeeeee7en]

Hi Community

I have a 8 Distinct Calculated List Boxes.

When I use Filters Suppose I Select the Name ABCD, the Associated and Possible data is Filtering out in the 5 List Boxes

and the remaining 3 List Boxes has no data associated with that selection.

What I need is to Hide those 3 non-associated List Boxes.

Is there any workaround???

Regards

Aviral Nag

[aveeeeeee7en]

Thanks Magal for your reply

I have a conditional list box which has Concatenated fields which contains text as well as Numbers and also it has Picture in it. So, it can't be possible with the Sum condition. Any other option.

[#3]

Can you post your sample data?

[aveeeeeee7en]

See the Attachment.

[#5]

use layout condition as below

=if(GetSelectedCount(Name3)>0,if(len(if(Level=2,Name&chr(13)&emp_location&chr(13)&Department))>0,1,0),1)