topic Displaying Records Matching a Criteria in QlikView https://community.qlik.com/t5/QlikView/Displaying-Records-Matching-a-Criteria/m-p/432078#M161082 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>I think this is fairly straightforward but I can't figure it out. </P><P></P><P>All I want to do is display a table but only containing records that match a certain criteria. A table box or even a straight table (chart) would be fine. I want to display a lit of "Detractors" and then a seperate list of "Promotors". Can someone show me the bets.easiest way fo doing this without the user having to filter? So if my data looks like this: </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Detractor</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Detractor</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Promoter</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Detractor</P><P></P><P>Then my "Promotor" table would only contain Company C. </P><P></P><P>Thanks for your help. </P><P></P><P>Stu</P></BODY></HTML> Mon, 08 Apr 2013 15:37:54 GMT stuwannop 2013-04-08T15:37:54Z Displaying Records Matching a Criteria https://community.qlik.com/t5/QlikView/Displaying-Records-Matching-a-Criteria/m-p/432078#M161082 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>I think this is fairly straightforward but I can't figure it out. </P><P></P><P>All I want to do is display a table but only containing records that match a certain criteria. A table box or even a straight table (chart) would be fine. I want to display a lit of "Detractors" and then a seperate list of "Promotors". Can someone show me the bets.easiest way fo doing this without the user having to filter? So if my data looks like this: </P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Detractor</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Detractor</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Promoter</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Company D&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Detractor</P><P></P><P>Then my "Promotor" table would only contain Company C. </P><P></P><P>Thanks for your help. </P><P></P><P>Stu</P></BODY></HTML> Mon, 08 Apr 2013 15:37:54 GMT https://community.qlik.com/t5/QlikView/Displaying-Records-Matching-a-Criteria/m-p/432078#M161082 stuwannop 2013-04-08T15:37:54Z Re: Displaying Records Matching a Criteria https://community.qlik.com/t5/QlikView/Displaying-Records-Matching-a-Criteria/m-p/432079#M161083 <HTML><HEAD></HEAD><BODY><P>If your first field is Company and your second field is Type:</P><P>In a straight table, define the Dimension as: =if(Type = 'Promoter',Company)</P></BODY></HTML> Mon, 08 Apr 2013 19:46:02 GMT https://community.qlik.com/t5/QlikView/Displaying-Records-Matching-a-Criteria/m-p/432079#M161083 m_woolf 2013-04-08T19:46:02Z Re: Displaying Records Matching a Criteria https://community.qlik.com/t5/QlikView/Displaying-Records-Matching-a-Criteria/m-p/432080#M161084 <HTML><HEAD></HEAD><BODY><P>Works a treat thank you very much! </P></BODY></HTML> Tue, 09 Apr 2013 07:44:41 GMT https://community.qlik.com/t5/QlikView/Displaying-Records-Matching-a-Criteria/m-p/432080#M161084 stuwannop 2013-04-09T07:44:41Z