topic Exclude a Dimension in QlikView https://community.qlik.com/t5/QlikView/Exclude-a-Dimension/m-p/180218#M46723 <HTML><HEAD></HEAD><BODY><P>Hey guys.</P><P>How do you exclude a certain dimension. eg i have a bunch of sites or areas labelled site. in site, theres a area called South. now how do i select everything to show except for South? i tried the following but its not workng:</P><P>=if(isnull(Site='South','0',Site))</P></BODY></HTML> Mon, 30 Aug 2010 12:28:13 GMT 2010-08-30T12:28:13Z Exclude a Dimension https://community.qlik.com/t5/QlikView/Exclude-a-Dimension/m-p/180218#M46723 <HTML><HEAD></HEAD><BODY><P>Hey guys.</P><P>How do you exclude a certain dimension. eg i have a bunch of sites or areas labelled site. in site, theres a area called South. now how do i select everything to show except for South? i tried the following but its not workng:</P><P>=if(isnull(Site='South','0',Site))</P></BODY></HTML> Mon, 30 Aug 2010 12:28:13 GMT https://community.qlik.com/t5/QlikView/Exclude-a-Dimension/m-p/180218#M46723 2010-08-30T12:28:13Z Exclude a Dimension https://community.qlik.com/t5/QlikView/Exclude-a-Dimension/m-p/180219#M46724 <HTML><HEAD></HEAD><BODY><P>Check the 'Suppress when value is null" box and use:</P><P>if(Site&lt;&gt;'South',Site)</P></BODY></HTML> Mon, 30 Aug 2010 12:37:10 GMT https://community.qlik.com/t5/QlikView/Exclude-a-Dimension/m-p/180219#M46724 Or 2010-08-30T12:37:10Z Exclude a Dimension https://community.qlik.com/t5/QlikView/Exclude-a-Dimension/m-p/180220#M46725 <HTML><HEAD></HEAD><BODY><P>Thanks man. I knew it was something simple i just couldn't remember. Thanks a bunch</P></BODY></HTML> Mon, 30 Aug 2010 12:40:01 GMT https://community.qlik.com/t5/QlikView/Exclude-a-Dimension/m-p/180220#M46725 2010-08-30T12:40:01Z