Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get n-th value in GetFieldSelections

Is there a way to select the n-th value in the list that GetFieldSelections() generates?

For example:

GetFieldSelections(Fruit) gives 'apple', 'orange', 'pear'

Is there any way for me to only get the second value that appears in GetFieldSelections?


Thank you!

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

=SubField(GetFieldSelections(Fruit),',',2)

You can also make it Dynamic Number

Create a variable vNumber

Now use an Input Box for vNumber where user can change the value

=SubField(GetFieldSelections(Fruit),',',vNumber)

View solution in original post

1 Reply
MK_QSL
MVP
MVP

=SubField(GetFieldSelections(Fruit),',',2)

You can also make it Dynamic Number

Create a variable vNumber

Now use an Input Box for vNumber where user can change the value

=SubField(GetFieldSelections(Fruit),',',vNumber)