
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
GetFieldSelection not working with a Pivot Table
Hi,
I am working on a basic dynamic title to go along with my pivot table. I want to show the Staff Name and Service Dates in the title when selections are made in the pivot table.
I am able to get the Service Date to be part of the title by using GetFieldSelections([Services.Service Date]) expression. However, that same expression does not work for Staff Name.
Here is the expression I have entered:
I want to show the Staff Name that is selected in the pivot table below.
I do not get an error in the expression, however, nothing is returned when a Staff Name is selected. It is not reflected in the title.
I have tried several different alternatives to GetFieldSelection including Concat (which returns ALL of the Staff Name until a selection is made), GetCurrentSelections (which does show the Staff Name, but also shows the Service Dates and looks messy in the title).
Any advice is greatly appreciated!! Very confused why this expression would be working for one field and not another when they are referencing the same pivot table.
Any advice is greatly appreciated!!
Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@AO1 maybe try the suggestions from Miguel in this post:
https://community.qlik.com/t5/QlikView-App-Dev/GetFieldSelections-Pivot-Table/td-p/303014


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Make sure that you really reference to the right field and not a similar one or to the label of field. Another look might go if it's a native field and not calculated one.
