Discussion board where members can get started with QlikView.
Hi all, o, trying to make another range for multibox to select range of the yield
but the error occurs as below
=If((Sum (ActYield)/Sum (Ha))<=5,'Mid',If((Sum (ActYield)/Sum (Ha))>=0,'Low'))
Go to Solution.
An aggregation like sum() needs always a context respectively any dimension to return a valid value for a calculated dimension - therefore it needs to be wrapped within an aggr() like:
aggr(YourExpression, Dim1, Dim2)
whereby Dim1, Dim2 are placeholder for the dimensions in which context it should be calculated.