GetFieldSelections Help

[Johnnyg248]

Please see attached qvw 

(for the sake of simplicity I have only included only 2 list boxes and  a very small sample of fields that could be selected)

I have some list boxes that I am using to filter straight table results.

The list boxes contain a concatenated field of code and description

I am populating text box using getfieldselections.  for ease of readability, was hoping to only have codes

show up in the selected field text box  (as shown in the textbox titled selections (wishlist)

I saw there was a get current selection box but unless I'm missing something doesn't seem like it provides the ability to do what I would like.

tried to use left string function but can't seem to get it to work

I would greatly appreciate any ideas.

[sunny_talwar]

May be use Concat instead

= 'Membership Type: ' & Concat(DISTINCT {} SubField(MemeberShipTypeDescription, ' - ', 1), ', ') & chr(13) & chr(13)
& 'Specialty: ' & Concat(DISTINCT {} SubField(SpecialtyCodeDescription, ' - ', 1), ', ')

[Johnnyg248 · Accepted solution]

Thanks so much for the reply!

I had a follow_up post but apparently forgot to click the post button!

I was looking for the selected values and not the  possible values

Did a bit more searching and ran across

https://community.qlik.com/t5/New-to-QlikView/Extracting-from-a-GetFieldSelections-result/td-p/32503...

From that I actually came to a solution that worked for me

I have attached the qvw in case it helps anyone