Discussion board where members can get started with QlikView.
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.
Thanking you in advance
Go to Solution.
Use calculated dimension
=if(Practice='unallocated', null(), Practice)
=aggr(if(Practice='unallocated', null(), Practice), Practice)