Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
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
MVP
MVP

Re: Get n-th value in GetFieldSelections

=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
MVP
MVP

Re: Get n-th value in GetFieldSelections

=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