https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-display-only-selected-fields-within-dimension/m-p/1815910#M9160 <P>Use the aggr() and replace the values with the desired values:</P><P>Aggr(Only({$&lt;[T1 Partner Name]={'Techn. . . .','AMTE. . . .','Ronlig. . . .'}&gt;} [T1 Partner Name]), [T1 Partner Name])</P> Thu, 17 Jun 2021 16:23:18 GMT GaryGiles 2021-06-17T16:23:18Z https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-display-only-selected-fields-within-dimension/m-p/1815893#M9159 <P>Hello there,</P><P>how to show only selected fields in my table with <U>no using</U> filter panel and alternate states?</P><P>Field: = [T1 Partner Name]</P><P>Any idea? Thanks for any help!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="1.JPG" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57039iFABCB633FEC7A844/image-size/medium?v=v2&amp;px=400" role="button" title="1.JPG" alt="1.JPG" /></span></P><P> </P><P>&nbsp;</P><P>&nbsp;</P> Thu, 17 Jun 2021 15:43:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-display-only-selected-fields-within-dimension/m-p/1815893#M9159 jacek2703 2021-06-17T15:43:18Z https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-display-only-selected-fields-within-dimension/m-p/1815910#M9160 <P>Use the aggr() and replace the values with the desired values:</P><P>Aggr(Only({$&lt;[T1 Partner Name]={'Techn. . . .','AMTE. . . .','Ronlig. . . .'}&gt;} [T1 Partner Name]), [T1 Partner Name])</P> Thu, 17 Jun 2021 16:23:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/How-to-display-only-selected-fields-within-dimension/m-p/1815910#M9160 GaryGiles 2021-06-17T16:23:18Z