Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
billuran
Partner - Creator
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
el_aprendiz111
Specialist
Specialist

Hi Bill

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

View solution in original post

10 Replies
vishsaggi
Champion III
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)

effinty2112
Master
Master

Hi Bill,

          Try this expression as the show condition:

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


Cheers


Andrew

Kushal_Chawda

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

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

el_aprendiz111
Specialist
Specialist

Hi Bill

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

billuran
Partner - Creator
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?

billuran
Partner - Creator
Partner - Creator
Author

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

billuran
Partner - Creator
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.

billuran
Partner - Creator
Partner - Creator
Author

Fer Fer this worked perfectly. Thanks!!

Kushal_Chawda

Try this


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