Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get the second value of the current selection

Hi All,

Does anyone know how to get the second value of the current selection?

For example I have a field Customer and currently the following customer have been selected:

1. John

2. Peter.

Does anyone know how to pick the second selection.

Thanks!

5 Replies
robert_mika
Master III
Master III

Try like this:

Textbetween(GetFieldSelections(Customer),',','')

trdandamudi
Master II
Master II

May be as below:

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

Anil_Babu_Samineni

Thirumala,

If we select 3 Items from Selectors, Then the above expression shows still 2nd Value only

Do you mean this?

=SubField(GetFieldSelections(Customer),',',-1)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Chanty4u
MVP
MVP

No anil. for your expression its giving last selected value. small change in your expression

=SubField(GetFieldSelections(key),',',-2)

te.PNGal.PNG

Anonymous
Not applicable
Author

Hi ,

use following expression :

=SubField(GetFieldSelections(Customer),',',-1)