topic Re: Show Conditional if value 'X' field is selected in QlikView

Show Conditional if value 'X' field is selected

billuran — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Show Conditional if value 'X' field is selected

vishsaggi — Fri, 01 Sep 2017 21:00:44 GMT

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)

Re: Show Conditional if value 'X' field is selected

effinty2112 — Fri, 01 Sep 2017 21:17:56 GMT

Hi Bill,

Try this expression as the show condition:

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

Cheers

Andrew

Re: Show Conditional if value 'X' field is selected

Kushal_Chawda — Sat, 02 Sep 2017 06:07:51 GMT

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

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

Re: Show Conditional if value 'X' field is selected

el_aprendiz111 — Sat, 02 Sep 2017 18:24:33 GMT

Hi Bill

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

Re: Show Conditional if value 'X' field is selected

billuran — Tue, 05 Sep 2017 14:26:44 GMT

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

Re: Show Conditional if value 'X' field is selected

billuran — Tue, 05 Sep 2017 14:29:27 GMT

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

Re: Show Conditional if value 'X' field is selected

billuran — Tue, 05 Sep 2017 14:33:52 GMT

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.

Re: Show Conditional if value 'X' field is selected

billuran — Tue, 05 Sep 2017 14:35:53 GMT

Fer Fer this worked perfectly. Thanks!!

Re: Show Conditional if value 'X' field is selected

Kushal_Chawda — Tue, 05 Sep 2017 14:39:51 GMT

Try this

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

Re: Show Conditional if value 'X' field is selected

billuran — Tue, 05 Sep 2017 15:32:29 GMT

Can you help me then to show another button if value is not selected IE my field does not equal X?