topic Re: define stright table date - qlik sense in App Development https://community.qlik.com/t5/App-Development/define-stright-table-date-qlik-sense/m-p/954272#M13583 <HTML><HEAD></HEAD><BODY><P>answered my own question</P><P></P><P></P><P>Aggr(Only({$&lt;SurveyID={2}, QuestionID={1}&gt;}Comments),Comments)</P><P></P><P>regards x</P></BODY></HTML> Tue, 15 Sep 2015 15:03:30 GMT joeybird 2015-09-15T15:03:30Z define stright table date - qlik sense https://community.qlik.com/t5/App-Development/define-stright-table-date-qlik-sense/m-p/954271#M13582 <HTML><HEAD></HEAD><BODY><P>Hiya</P><P></P><P>I wish to define data shown in a table in a sheet.</P><P></P><P>example if I was using a kpi I would use something like</P><P></P><P></P><P>count ({$&lt; SurveyID ={"2"}&gt;}SurveyPersonID)</P><P></P><P>but I want a table in the sheet to only show me the SurveyPersonID for SurveyID 2 only .</P><P></P><P>I need to sort by expression but I have no joy</P><P></P><P>how is this achieved please in qlik sense</P><P></P><P>kind regards</P><P><BR /> </P></BODY></HTML> Tue, 15 Sep 2015 12:10:04 GMT https://community.qlik.com/t5/App-Development/define-stright-table-date-qlik-sense/m-p/954271#M13582 joeybird 2015-09-15T12:10:04Z Re: define stright table date - qlik sense https://community.qlik.com/t5/App-Development/define-stright-table-date-qlik-sense/m-p/954272#M13583 <HTML><HEAD></HEAD><BODY><P>answered my own question</P><P></P><P></P><P>Aggr(Only({$&lt;SurveyID={2}, QuestionID={1}&gt;}Comments),Comments)</P><P></P><P>regards x</P></BODY></HTML> Tue, 15 Sep 2015 15:03:30 GMT https://community.qlik.com/t5/App-Development/define-stright-table-date-qlik-sense/m-p/954272#M13583 joeybird 2015-09-15T15:03:30Z