Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for
Did you mean:
Partner - Creator

## Show Conditional if value 'X' field is selected

Hello, I have a button i want to show if value X is selected regardless if Y is selected as well. So show button if at least X is selected. here is actual formula which works if only 1 value is selected.

[BM STAFF]='Ancillary'

I am sure its an easy solution.

Bill

1 Solution

Accepted Solutions
Specialist

Hi Bill

=count(distinct if(MyField='x',0))

10 Replies
Champion III

Can you write an OR condition to show this. Can you share you actual expression where you are using this.

May be like this in your button conditional check expression

= IF(GetSelectedCount(YourfieldName) > 0, 1, 0)

Master

Hi Bill,

Try this expression as the show condition:

Wildmatch(GetFieldSelections([BM STAFF],'|')'Ancillary')

Cheers

Andrew

Go to button properties->Layout ->Conditional, put below expression

=if(match([BM STAFF],'Ancillary'),1,0)

Specialist

Hi Bill

=count(distinct if(MyField='x',0))

Partner - Creator
Author

Thanks, However it needs to have the condition that if "Ancillary' is not selected it wont show. This is for any selection. Thoughts?

Partner - Creator
Author

Andrew it is showing even if nothing or something is selected. Thoughts?

Partner - Creator
Author

Thanks Kushal, However it is still hidden even if more then just Ancillary is selected. I want it shown if Ancillary is selected and if anything else selected aswell.

Partner - Creator
Author

Fer Fer this worked perfectly. Thanks!!

Try this

=if(wildmatch(concat(distinct [BM STAFF], ',') ,'*Ancillary*'),1,0)

Community Browser