topic How to exclude a fieldname within a chart in QlikView https://community.qlik.com/t5/QlikView/How-to-exclude-a-fieldname-within-a-chart/m-p/382523#M1168328 <HTML><HEAD></HEAD><BODY><P>I have a chart which totals the cost for "Practices". The chart includes a fieldname called "unallocated" within a dimension called "Practice" and I want to exclude the "unallocated". Any assistance would be appreciated. I have attached the chart. </P><P></P><P>Thanking you in advance</P><P></P><P>Claire </P></BODY></HTML> Thu, 30 Aug 2012 15:04:54 GMT 2012-08-30T15:04:54Z How to exclude a fieldname within a chart https://community.qlik.com/t5/QlikView/How-to-exclude-a-fieldname-within-a-chart/m-p/382523#M1168328 <HTML><HEAD></HEAD><BODY><P>I have a chart which totals the cost for "Practices". The chart includes a fieldname called "unallocated" within a dimension called "Practice" and I want to exclude the "unallocated". Any assistance would be appreciated. I have attached the chart. </P><P></P><P>Thanking you in advance</P><P></P><P>Claire </P></BODY></HTML> Thu, 30 Aug 2012 15:04:54 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-a-fieldname-within-a-chart/m-p/382523#M1168328 2012-08-30T15:04:54Z Re: How to exclude a fieldname within a chart https://community.qlik.com/t5/QlikView/How-to-exclude-a-fieldname-within-a-chart/m-p/382524#M1168329 <HTML><HEAD></HEAD><BODY><P>Use calculated dimension</P><P>=if(Practice='unallocated', null(), Practice)</P><P>or</P><P>=aggr(if(Practice='unallocated', null(), Practice), Practice)</P></BODY></HTML> Thu, 30 Aug 2012 15:23:48 GMT https://community.qlik.com/t5/QlikView/How-to-exclude-a-fieldname-within-a-chart/m-p/382524#M1168329 whiteline 2012-08-30T15:23:48Z