topic Re: Excluding Specific Items from a Dimension in QlikView https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438831#M163547 <HTML><HEAD></HEAD><BODY><P>You may need to check option 'Supress when Value is NULL' on dimension tab.</P></BODY></HTML> Mon, 21 Jan 2013 13:00:10 GMT swuehl 2013-01-21T13:00:10Z Excluding Specific Items from a Dimension https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438828#M163544 <HTML><HEAD></HEAD><BODY><P>I have included a Dimension in my straight table that has a number of different sections, i.e. Hardware, Software, Licences, Services however within this table I would like to always exclude some of these.&nbsp; Rather than put Set Analysis into each of these is it possible to set something within this Dimension to always exclude certain sections within this table.&nbsp; e.g. of the list above how could I always exlude Hardware and Software from the Dimension, within this table only.</P></BODY></HTML> Mon, 21 Jan 2013 12:32:11 GMT https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438828#M163544 2013-01-21T12:32:11Z Re: Excluding Specific Items from a Dimension https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438829#M163545 <HTML><HEAD></HEAD><BODY><P>You can use a calculated dimension, something like</P><P></P><P>=if( not match(DIMENSIONFIELD,'Software', 'Hardware'), DIMENSIONFIELD)</P></BODY></HTML> Mon, 21 Jan 2013 12:36:23 GMT https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438829#M163545 swuehl 2013-01-21T12:36:23Z Re: Excluding Specific Items from a Dimension https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438830#M163546 <HTML><HEAD></HEAD><BODY><P>Thanks Swuehl however this only creates a new dimension and replaces the description of Software &amp; Hardware with a - rather than exlcuding them altogether.&nbsp; Do you have any further suggestions?</P></BODY></HTML> Mon, 21 Jan 2013 12:56:24 GMT https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438830#M163546 2013-01-21T12:56:24Z Re: Excluding Specific Items from a Dimension https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438831#M163547 <HTML><HEAD></HEAD><BODY><P>You may need to check option 'Supress when Value is NULL' on dimension tab.</P></BODY></HTML> Mon, 21 Jan 2013 13:00:10 GMT https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438831#M163547 swuehl 2013-01-21T13:00:10Z Re: Excluding Specific Items from a Dimension https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438832#M163548 <HTML><HEAD></HEAD><BODY><P>Excellent, thanks, works a treat</P></BODY></HTML> Mon, 21 Jan 2013 13:03:12 GMT https://community.qlik.com/t5/QlikView/Excluding-Specific-Items-from-a-Dimension/m-p/438832#M163548 2013-01-21T13:03:12Z