https://community.qlik.com/t5/App-Development/Filtering-rows-of-a-straight-table-in-Qlik-Sense/m-p/1688286#M52488 <P>I have a straight table like following</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ID_Delph&nbsp;&nbsp;</P><P>EVE00188&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>EVE00189&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>EVE00190&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>EVE00191&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>INC00188&nbsp; &nbsp; &nbsp; 99120</P><P>INC00189&nbsp; &nbsp; &nbsp; 99121</P><P>INC00190&nbsp; &nbsp; &nbsp; 99122</P><P>INC00191&nbsp; &nbsp; &nbsp; 99123</P><P>What I want to do, is filter out every ID that contains EVE*, so I can only see the ones with INC*, but I tried with this&nbsp;aggr(only({&lt;ID_INCEVE_RTI = {'INC*'}&gt;},),ID_INCEVE_RTI) and this if (ID_INCEVE_RTI = 'INC*',&nbsp;ID_INCEVE_RTI), and both of them did filter out EVE* IDs, but I can't see INC* IDs rigth now because they show like these</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>ID&nbsp; | ID_Delph</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99120</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99121</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99122</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99123</P><P>&nbsp;</P> Mon, 20 Dec 2021 21:32:42 GMT AndresCR14 2021-12-20T21:32:42Z https://community.qlik.com/t5/App-Development/Filtering-rows-of-a-straight-table-in-Qlik-Sense/m-p/1688286#M52488 <P>I have a straight table like following</P><P>ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ID_Delph&nbsp;&nbsp;</P><P>EVE00188&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>EVE00189&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>EVE00190&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>EVE00191&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; -</P><P>INC00188&nbsp; &nbsp; &nbsp; 99120</P><P>INC00189&nbsp; &nbsp; &nbsp; 99121</P><P>INC00190&nbsp; &nbsp; &nbsp; 99122</P><P>INC00191&nbsp; &nbsp; &nbsp; 99123</P><P>What I want to do, is filter out every ID that contains EVE*, so I can only see the ones with INC*, but I tried with this&nbsp;aggr(only({&lt;ID_INCEVE_RTI = {'INC*'}&gt;},),ID_INCEVE_RTI) and this if (ID_INCEVE_RTI = 'INC*',&nbsp;ID_INCEVE_RTI), and both of them did filter out EVE* IDs, but I can't see INC* IDs rigth now because they show like these</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P>ID&nbsp; | ID_Delph</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99120</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99121</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99122</P><P>-&nbsp; &nbsp; &nbsp;|&nbsp; 99123</P><P>&nbsp;</P> Mon, 20 Dec 2021 21:32:42 GMT https://community.qlik.com/t5/App-Development/Filtering-rows-of-a-straight-table-in-Qlik-Sense/m-p/1688286#M52488 AndresCR14 2021-12-20T21:32:42Z