GetCurrentSelection does not work properly

[Breezy]

Hi,

This is my first time using the "GetCurrentSelections" function. In my first two examples it appears to work how I want it to work. However, in my third example of my KPI , when I choose two people from "FirstName", it just gives me a dash line instead of the two people! How do I resolve this? It should say "Matt, Linda."

[Øystein_Kolsrud · Accepted solution]

You're referring directly to the field "FirstName" in the first condition of your if-statement. I suspect you need to aggregate that values of that field somehow, probably like this:

=if(Count(GetCurrentSelections()) > 0, Concat(Distinct FirstName, ', '), 'Please select a name')

[Breezy]

Yessssssssss. That worked! Thank you! 🙂

[Øystein_Kolsrud]

Good! But you might want to have a look at this function:

https://help.qlik.com/en-US/sense/November2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/Field...

It allows you to show only the selected values in a specific field.

[Breezy]

I'll take a look. Thanks!