Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

GetFieldSelections not working correctly - Bug

Hi There

I observed on behavior when using GetFieldSelections function.


I am using Filter objects. I am typing some text to search the required value and hit enter.


When i do that the value is getting selected in the selected panel , however in the GetFieldSelections function I am seeing only the text value which I have typed.


I should see the full related value of the field.


Is there something wrong ?


I am using following Title Expression,

='KPI Dashboard' & '   -   ' & GetFieldSelections([Project Manager Name])

Please find attached screenshot.

5 Replies
ychaitanya
Creator III
Creator III

Can you try using.

=if(getselectedcount([Project Manager Name])>0,'KPI Dashboard' & '   -   ' & Concat(DISTINCT [Project Manager Name],','))

agigliotti
Partner - Champion
Partner - Champion

that's because you have selected more than one Project Manager.

ashishpalkar
Creator III
Creator III
Author

Thanks , initially when I load the App it shows heading as '-', it should show 'KPI Dashboard'

jonathandienst
Partner - Champion III
Partner - Champion III

You are seeing the documented behaviour of GetFieldSelections(). If the selection was via a search string, it will return the search string ('neel' in your case, which returns any names containing the 'neel').

You may need to use something like Only() or Concat() to get the currently 'possible' values.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jonathandienst
Partner - Champion III
Partner - Champion III

>> initially when I load the App it shows heading as '-', it should show 'KPI Dashboard'

GetFieldSelections() returns a null if nothing is selected, and concatenating a null value with the '&' operator causes a null result. You need something like:


='KPI Dashboard' & If(GetSelectedCount([Project Manager Name]) = 1, '   -   ' & Only([Project Manager Name]))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein