Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

iliaisyah
New Contributor III

Range appear in grey

Hi all, o, trying to make another range for multibox to select range of the yield

 

but the error occurs as below

567.png4567.png

 

=If((Sum (ActYield)/Sum (Ha))<=5,'Mid',If((Sum (ActYield)/Sum (Ha))>=0,'Low'))

Labels (1)
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Range appear in grey

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.

- Marcus

1 Reply
MVP & Luminary
MVP & Luminary

Re: Range appear in grey

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.

- Marcus