Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
adiarnon
Creator III
Creator III

HIDE OBJECT

HI,

i want to hide object base on condition

the condition should be-

i should see the object im the current selection is empty

or

if the the curren selection have field - "employee","department","division"

if one or more of those fields and only those fields are selected i should see the object.

if a selection made on any othe field i want to hide the object.

how can i do it?

adi

12 Replies
Digvijay_Singh

You may try using system field $Field as -

=WildMatch(GetFieldSelections($Field),'*Customer Name*','*Country*','*ChannelId*')

This will show object if listed three fields are selected(any combination), if rest of the fields are selected, condition will be false.

sasikanth
Master
Master

Other than the specified conditions if you select any filter it will be hided ..

adiarnon
Creator III
Creator III
Author

i found a solution-

=if(isnull(SubStringCount( GetCurrentSelections(':', ',', '@', 100), ':')+1),1,
if( SubStringCount( GetCurrentSelections(':', ',', '@', 100), ':')+1>
(
WildMatch(getcurrentselections (':', '=', ';', 0 ),'*employee=*')
+
WildMatch(getcurrentselections (':', '=', ';', 0 ),'*department=*')
+
WildMatch(getcurrentselections (':', '=', ';', 0 ),'*division')),0,1))