Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

define stright table date - qlik sense

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


1 Solution

Accepted Solutions
joeybird
Contributor II

Re: define stright table date - qlik sense

answered my own question

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

regards x

1 Reply
joeybird
Contributor II

Re: define stright table date - qlik sense

answered my own question

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

regards x

Community Browser