https://community.qlik.com/t5/QlikView/Exclude-value-in-Dimension/m-p/1627228#M733266 <P>You don't need 'Enable Conditional' expression here, instead use 'Calculated dimension' (click on 'Add Calculated Dimension'). Use the expression like below:</P><P>=If(<SPAN>Team&lt;&gt;'Alfa',&nbsp;Team)</SPAN></P><P>&nbsp;</P><P><SPAN>And check&nbsp; 'Suppress When Value is Null'</SPAN></P> Tue, 24 Sep 2019 06:38:02 GMT tresB 2019-09-24T06:38:02Z https://community.qlik.com/t5/QlikView/Exclude-value-in-Dimension/m-p/1627224#M733265 <P>Hello everyone,</P><P>I want to <U><STRONG>exclude</STRONG> </U>"Alfa" team in my pivot table. I need to see only Beta and Charlie values. What should i write in the "Enable Conditional" exactly?</P><P>I can't in Expression because i have too much expression. Is it possible to way doing in Dimensions tab?</P><P>&nbsp;</P><P>Here is the "Team" list:</P><P>&nbsp;</P><P>Alfa</P><P>Beta</P><P>Charlie</P><P>&nbsp;</P><P>and here is the my Dimensions Tab:</P><DIV class="mceNonEditable lia-copypaste-placeholder">&nbsp;</DIV><P><IMG src="https://community.qlik.com/t5/image/serverpage/image-id/19566iB1615757F15952C5/image-size/large?v=1.0&amp;px=-1" border="0" width="631" height="593" title="Capture.PNG" alt="Capture.PNG" /></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Exclude-value-in-Dimension/m-p/1627224#M733265 asknyldz 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Exclude-value-in-Dimension/m-p/1627228#M733266 <P>You don't need 'Enable Conditional' expression here, instead use 'Calculated dimension' (click on 'Add Calculated Dimension'). Use the expression like below:</P><P>=If(<SPAN>Team&lt;&gt;'Alfa',&nbsp;Team)</SPAN></P><P>&nbsp;</P><P><SPAN>And check&nbsp; 'Suppress When Value is Null'</SPAN></P> Tue, 24 Sep 2019 06:38:02 GMT https://community.qlik.com/t5/QlikView/Exclude-value-in-Dimension/m-p/1627228#M733266 tresB 2019-09-24T06:38:02Z