define stright table date - qlik sense

[joeybird]

Hiya

I wish to define data shown in a table in a sheet.

example if I was using a kpi I would use something like

count ({$< SurveyID ={"2"}>}SurveyPersonID)

but I want a table in the sheet to only show me the SurveyPersonID for SurveyID 2 only .

I need to sort by expression but I have no joy

how is this achieved please in qlik sense

kind regards

[joeybird · Accepted solution]

answered my own question

Aggr(Only({$<SurveyID={2}, QuestionID={1}>}Comments),Comments)

regards x