Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Johnnyg248
Contributor III
Contributor III

GetFieldSelections Help

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.

 

 

 

 

 

 

1 Solution

Accepted Solutions
Johnnyg248
Contributor III
Contributor III
Author

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

 

 

 

View solution in original post

2 Replies
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
Contributor III
Contributor III
Author

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

 

 

 

View solution in original post