topic Conditional text box help in QlikView

Conditional text box help

Wed, 25 Nov 2020 16:16:04 GMT

I have this scenario

I have a parameter (Client) which can have a lot of fixed values (e.g A, B, C, D, E, F, G).

I have a text box that I want to show when Client = A or B or C or any combination of the 3 (we could have one selected or 2 or 3). The text box will be hidden when any other value is selected.

Any idea how I can do that?

Doing an if(Match(Client,A,B,C),0,1) does not return a 0 when A, B and C are all selected or any combination of 2 of the 3 are selected.

Please advise.

Thanks,
Amit

Re: Conditional text box help

sunny_talwar — Mon, 07 Mar 2016 16:25:43 GMT

May be this as your hide/show condition:

SubStringCount(Concat(DISTINCT Client, '|'), 'A') = 1 or

SubStringCount(Concat(DISTINCT Client, '|'), 'B') = 1 or

SubStringCount(Concat(DISTINCT Client, '|'), 'C') = 1

Re: Conditional text box help

Kushal_Chawda — Mon, 07 Mar 2016 16:31:08 GMT

Write the below expression in Conditional of Layout tab of text object

=if(wildmatch(getfieldselections(Client),'*A*') or

wildmatch(getfieldselections(Client),'*B*') or

wildmatch(getfieldselections(Client),'*C*'),1,0)