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: 
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)