Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
kmstephenson
Contributor

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
mwoolf
Honored Contributor II

Re: How to add characters to GetFieldSelections string

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
mwoolf
Honored Contributor II

Re: How to add characters to GetFieldSelections string

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