Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
guster999
Contributor III
Contributor III

Qlik Sense action button for selecting multiple values in a field

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
15 Replies
guster999
Contributor III
Contributor III
Author

tried as below but still no luck

guster999_0-1591824058173.png

 

TarekHajji
Contributor II
Contributor II

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

guster999
Contributor III
Contributor III
Author

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

guster999_0-1591841494952.png

 

_ylc
Partner - Creator
Partner - Creator

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

Anyway, here's what's working:

_ylc_0-1591845267838.png

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

Give it a try and it worked for me 🙂

guster999
Contributor III
Contributor III
Author

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

cheers 😊

chapil
Contributor III
Contributor III

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