topic Filter values in a dimension. in QlikView https://community.qlik.com/t5/QlikView/Filter-values-in-a-dimension/m-p/557734#M1130826 <HTML><HEAD></HEAD><BODY><P>Hello.<BR />I am creating a Pivot Chart. I have a dimension Population_Category. There are 3 distinct types in Population_Category. These are: Rural Population, Urban Population and Total Population. <BR />Could you please help me to filter only two types: Rural and Urban population, in chart properties? Is it possible in Edit Expression?<BR />Thanks in advance!!</P></BODY></HTML> Wed, 11 Dec 2013 09:39:12 GMT 2013-12-11T09:39:12Z Filter values in a dimension. https://community.qlik.com/t5/QlikView/Filter-values-in-a-dimension/m-p/557734#M1130826 <HTML><HEAD></HEAD><BODY><P>Hello.<BR />I am creating a Pivot Chart. I have a dimension Population_Category. There are 3 distinct types in Population_Category. These are: Rural Population, Urban Population and Total Population. <BR />Could you please help me to filter only two types: Rural and Urban population, in chart properties? Is it possible in Edit Expression?<BR />Thanks in advance!!</P></BODY></HTML> Wed, 11 Dec 2013 09:39:12 GMT https://community.qlik.com/t5/QlikView/Filter-values-in-a-dimension/m-p/557734#M1130826 2013-12-11T09:39:12Z Re: Filter values in a dimension. https://community.qlik.com/t5/QlikView/Filter-values-in-a-dimension/m-p/557735#M1130828 <HTML><HEAD></HEAD><BODY><P>The filtering needs to be done in the dimension level and not in expression. Go to dimension tab -</P><P></P><P>Include this in the calculated dimension areas...below is an example</P><P>=if(pop='urban','urban',if(pop='rural','rural'))</P><P></P><P>and check Suppress when value is null option.</P></BODY></HTML> Wed, 11 Dec 2013 11:57:53 GMT https://community.qlik.com/t5/QlikView/Filter-values-in-a-dimension/m-p/557735#M1130828 2013-12-11T11:57:53Z Re: Filter values in a dimension. https://community.qlik.com/t5/QlikView/Filter-values-in-a-dimension/m-p/557736#M1130830 <HTML><HEAD></HEAD><BODY><P>Thanks Siva. It works.</P></BODY></HTML> Wed, 11 Dec 2013 18:06:11 GMT https://community.qlik.com/t5/QlikView/Filter-values-in-a-dimension/m-p/557736#M1130830 2013-12-11T18:06:11Z