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: 
Not applicable

How to Hide an object if there is no selection

I need an expression for conditional show to hide a text box when no selection is taken.

Thanks

1 Solution

Accepted Solutions
Not applicable
Author

Thanks to you Gents I was able to solve it.

if(GetSelectedCount([AnyObjectOnSheet])=1 and not IsNull([Extended Till]),1,0)

best regards,

Wael

View solution in original post

8 Replies
muniyandi
Creator III
Creator III

Hi,

Try this expression it works.

Textbox-->Layout-->show-->conditional-->

IF(Count(distinct [Customerid]) >1, 0,1)

Regards,

Muni

Sokkorn
Master
Master

Hi,

First Right Click on Text object ==> Layout tab ==> Conditional = NOT ISNULL(GetFieldSelections(YourField))

Untitled.jpg

Hope this help.

Regards,

Sokkorn

Not applicable
Author

Thanks for your tip.

what I am trying to do is to get [Extended Till] Date if there was an extension from my data, and it works perfectly with the following formula

if(IsNull([Extended Till]),0,1)

now what I want to add is that if I clear all selections from my entire sheet, I want this box to disapear

Best regards,

Wael

Sokkorn
Master
Master

Hi Wael,

Did you try expression NOT ISNULL(GetFieldSelections([Extended Till])) yet? This work for me when I clear selected values.

Regards,

Sokkorn

Not applicable
Author

Sokkorn,

Thanks for your reply I tried it but didn’t work!! The box totally disappears and even when I do have an extension (TRUE VALUE)

maybe cuz my sheet is a bit complicated ☹

regards,

Wael

Sokkorn
Master
Master

Hi Wael,

Can you share your app? It may easy to find solution.

Regards,

Sokkorn

Not applicable
Author

Thanks to you Gents I was able to solve it.

if(GetSelectedCount([AnyObjectOnSheet])=1 and not IsNull([Extended Till]),1,0)

best regards,

Wael

Sokkorn
Master
Master

Well done Wael.

Cheer!!