topic Re: Excluding particular dimensions in QlikView https://community.qlik.com/t5/QlikView/Excluding-particular-dimensions/m-p/477884#M1139883 <HTML><HEAD></HEAD><BODY><P>Very helpful thank you!</P></BODY></HTML> Wed, 25 Sep 2013 17:17:21 GMT 2013-09-25T17:17:21Z Excluding particular dimensions https://community.qlik.com/t5/QlikView/Excluding-particular-dimensions/m-p/477882#M1139881 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have a bar chart but I do not want to show particular dimensions because they do not have a Target Grade assigned (see image Original).</P><P></P><P>So I have used&nbsp; the following calculated dimension to strip out the dimension which does not have&nbsp; target grade:</P><P></P><P>=if( not wildmatch(Procedures,'*Tests of Control*','*CAAT*'),Procedures)</P><P></P><P>However, instead of removing the dimension completely, it has created a chart column at the very end with a dimension of a "." . See image (New). </P><P></P><P>I want to get rid of this. Please help.</P></BODY></HTML> Wed, 25 Sep 2013 15:40:36 GMT https://community.qlik.com/t5/QlikView/Excluding-particular-dimensions/m-p/477882#M1139881 2013-09-25T15:40:36Z Re: Excluding particular dimensions https://community.qlik.com/t5/QlikView/Excluding-particular-dimensions/m-p/477883#M1139882 <HTML><HEAD></HEAD><BODY><P>Check the option 'Suppress when Value is NULL' on dimension tab of chart properties.</P></BODY></HTML> Wed, 25 Sep 2013 15:52:14 GMT https://community.qlik.com/t5/QlikView/Excluding-particular-dimensions/m-p/477883#M1139882 swuehl 2013-09-25T15:52:14Z Re: Excluding particular dimensions https://community.qlik.com/t5/QlikView/Excluding-particular-dimensions/m-p/477884#M1139883 <HTML><HEAD></HEAD><BODY><P>Very helpful thank you!</P></BODY></HTML> Wed, 25 Sep 2013 17:17:21 GMT https://community.qlik.com/t5/QlikView/Excluding-particular-dimensions/m-p/477884#M1139883 2013-09-25T17:17:21Z