topic Re: GetFieldSelections Help in QlikView

GetFieldSelections Help

Johnnyg248 — Wed, 07 Aug 2019 18:57:33 GMT

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.

Re: GetFieldSelections Help

sunny_talwar — Wed, 07 Aug 2019 19:54:19 GMT

May be use Concat instead

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

Re: GetFieldSelections Help

Johnnyg248 — Thu, 08 Aug 2019 17:48:06 GMT

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/325035

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

I have attached the qvw in case it helps anyone