Listing the text of all names based on another field value

[paul123]

I am new to Qlik Sense and this may be incredibly simple.

I need to be able to show all pupil names in a KPI box based on their text scores equaling a specific amount.  For example in the following table Dave, Joe and Sam have a NRSS Maths score of 90 and I would like to just be able to show a list of their names in a KPI box.

PupilName	NRSS Maths
Dave	90
Barry	69
Jane	132
Alice	69
Jenny	119
Joe	90
Matthew	85
Sam	90
Daisy	108

I have tried:

= Only({<[NRSS Maths] = {'90'}>} [PupilName])

but this only returns a specific pupil if nobody else has the same score.

Thanks

[lironbaram · Accepted solution]

concat({<[NRSS Maths] = {'90'}>} distinct [PupilName],',')

[paul123]

Brilliant - works perfectly - many thanks.