Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: How to Hide an object if there is no selection

Thanks to you Gents I was able to solve it.

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

best regards,

Wael

8 Replies
muniyandi
Contributor III

How to Hide an object if there is no selection

Hi,

Try this expression it works.

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

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

Regards,

Muni

Sokkorn
Honored Contributor

How to Hide an object if there is no selection

Hi,

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

Untitled.jpg

Hope this help.

Regards,

Sokkorn

Not applicable

How to Hide an object if there is no selection

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
Honored Contributor

How to Hide an object if there is no selection

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

Re: How to Hide an object if there is no selection

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
Honored Contributor

Re: How to Hide an object if there is no selection

Hi Wael,

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

Regards,

Sokkorn

Not applicable

Re: How to Hide an object if there is no selection

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
Honored Contributor

How to Hide an object if there is no selection

Well done Wael.

Cheer!!

Community Browser