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

[_ylc · Accepted solution]

use this:

35A01 EAS REFERRAL FOR UCC;35A02 GP REFERRAL FOR UCC;35A03 NURSE REFERRAL FOR UCC

[guster999]

many thanks, that worked a treat!  I hope that also clarifies it for others who had been querying the issue.

To enhance the action button further, is there an equivalent for '35*' or using the wildcard ? other values will be added over time but will always start with 35.    

thanks

[_ylc]

That is possible. You select the 'Select value in a field' and the value is ='35*'

[guster999]

I had done that, but nothing is selected when the button is used.

But the previous method will work , so many thanks.

[_ylc]

May I know your qlik sense version?

[guster999]

[cid:image001.png@01D63F40.7021ABC0]

[_ylc]

Apologies but I cannot see the image.

I'm using November 2019 and it's working properly.

Here's what my button action looks like:

How it filtered:

[guster999]

I am using April 2020 version.

note that the options appear slightly different to yours  i.e. 'select values in a field'

Thanks for your images. I tried below settings but no response when I click the button.

[_ylc]

Can you try with the equal sign? ='35*'