topic How to conditional show/hide an object based on multiple fields in QlikView

How to conditional show/hide an object based on multiple fields

Tue, 02 Oct 2012 18:57:19 GMT

Hello,

I want to only show an object if 4 fields are selected, does anyone know the correct syntax?

Example:

field1='1' <- this does hide the object

field1='1' & field2='1' & field3='1' <- this does not hide the object

I figure it is either not possible, or I am just not getting the syntax right.

Thanks,

Tyler

Tue, 02 Oct 2012 19:02:07 GMT

Try this:

GetSelectedCount(Field1)>0 and GetSelectedCount(Field2)>0 and GetSelectedCount(Field3)>0

Tue, 02 Oct 2012 19:03:45 GMT

I didnt use the getselectedcount but the 'and' syntax is what i was missing.

field1='1' and field2='1' works! Thanks!