Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
answered my own question
Aggr(Only({$<SurveyID={2}, QuestionID={1}>}Comments),Comments)
regards x
answered my own question
Aggr(Only({$<SurveyID={2}, QuestionID={1}>}Comments),Comments)
regards x