Qlik Sense action button for selecting multiple values in a field

[guster999]

Hi,

I have found multiple posts for this but none have worked.

I'm trying to create an action button for multiple values of a field.  It works fine for 1 value from the list below, but I cannot seem to get the syntax right for all 3 field values below.

 Action=set values in a field

field = Problem

value = '35A01 EAS REFERRAL FOR UCC'   (this works okay - for any single value from below)

bit I need all 3 below included??

(I have tried with quotes and without, pipe separators...etc...)

35A01 EAS REFERRAL FOR UCC

35A02 GP REFERRAL FOR UCC

35A03 NURSE REFERRAL FOR UCC

[guster999]

tried as below but still no luck

[TarekHajji]

Try replace the simple quotes with doubles quotes ="35*"

[guster999]

That produces a red border (error?) and still no result

[_ylc · Accepted solution]

Ok, so I tried to upgrade to April 2020 and for some reasons, it's not working.

Anyway, here's what's working:

=Concat(distinct {<ID={"35*"}>} ID, ';')

Give it a try and it worked for me 🙂

[guster999]

that worked perfectly!!!  thanks so much and a clever solution, really appreciate the assistance.

cheers 😊

[chapil]

Hello guys, 

I have the same request but for me, it doesn't work like this and I don't have commun items between my values so can't use the other solution

DOC :  values 5R and 3H for example 

This expression makes an error : =3H;5R

Thanks