Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kmstephenson
Creator
Creator

How to add characters to GetFieldSelections string

Hi All,

I'd like to use GetFieldSelections to get a list of values selected in a field. However, given the values are in the following format, it's challenging to separate out values when more than one name is selected:

LAST NAME, FIRST NAME MIDDLE INITIAL

Example with multiple values:

DOE, JOHN A, DOE, JANE B

I'd like to further separate values so that these are easier to read. Also, not all values have a comma. For example, there may be the value UNKNOWN.

Can I use GetFieldSelections with another function to format this list so that it's easier to read?

I.e. Add in numbers

(1) DOE, JOHN A, (2) DOE, JANE B

Or  use value other than comma to separate values

DOE, JOHN A / DOE, JANE B

Thanks!

Kristina

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

The syntax for GetFieldSelections is:

GetFieldSelections ( field_name [, value_sep [, max_values]])

You can use ,'/' for the value_sep argument.

View solution in original post

1 Reply
m_woolf
Master II
Master II

The syntax for GetFieldSelections is:

GetFieldSelections ( field_name [, value_sep [, max_values]])

You can use ,'/' for the value_sep argument.