https://community.qlik.com/t5/QlikView/Range-appear-in-grey/m-p/1556389#M743211 <P>Hi all, o, trying to make another range for multibox to select range of the yield</P><P>&nbsp;</P><P>but the error occurs as below</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="567.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7979i05F07A8FF03D5D2E/image-size/large?v=v2&amp;px=999" role="button" title="567.png" alt="567.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="4567.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7980iC266D5932ECE1586/image-size/large?v=v2&amp;px=999" role="button" title="4567.png" alt="4567.png" /></span></P><P>&nbsp;</P><P>=If((Sum (ActYield)/Sum (Ha))&lt;=5,'Mid',If((Sum (ActYield)/Sum (Ha))&gt;=0,'Low'))</P> Sat, 16 Nov 2024 04:10:41 GMT iliaisyah 2024-11-16T04:10:41Z https://community.qlik.com/t5/QlikView/Range-appear-in-grey/m-p/1556389#M743211 <P>Hi all, o, trying to make another range for multibox to select range of the yield</P><P>&nbsp;</P><P>but the error occurs as below</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="567.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7979i05F07A8FF03D5D2E/image-size/large?v=v2&amp;px=999" role="button" title="567.png" alt="567.png" /></span><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="4567.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/7980iC266D5932ECE1586/image-size/large?v=v2&amp;px=999" role="button" title="4567.png" alt="4567.png" /></span></P><P>&nbsp;</P><P>=If((Sum (ActYield)/Sum (Ha))&lt;=5,'Mid',If((Sum (ActYield)/Sum (Ha))&gt;=0,'Low'))</P> Sat, 16 Nov 2024 04:10:41 GMT https://community.qlik.com/t5/QlikView/Range-appear-in-grey/m-p/1556389#M743211 iliaisyah 2024-11-16T04:10:41Z https://community.qlik.com/t5/QlikView/Range-appear-in-grey/m-p/1556568#M743212 <P>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:</P><P>aggr(YourExpression, Dim1, Dim2)</P><P>whereby Dim1, Dim2 are placeholder for the dimensions in which context it should be calculated.</P><P>- Marcus</P> Thu, 14 Mar 2019 13:53:46 GMT https://community.qlik.com/t5/QlikView/Range-appear-in-grey/m-p/1556568#M743212 marcus_sommer 2019-03-14T13:53:46Z