https://community.qlik.com/t5/QlikView/Nested-Error/m-p/1896448#M1217560 <P>Hello,<BR />I have used 2 expressions in 2 charts.<BR />To calculate the sum of that expression I have tried the following expressions and they are causing following errors:<BR />1.=Sum(If(F=0,Interval(Max(StopTime)-StartTime,'hh:mm:ss.fff')))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//In chart Im getting the correct column wo error<BR />&nbsp; &nbsp; &nbsp; &nbsp;Error:Error in expression:Nested aggregation not allowed<BR />2.=Min(If(Fail=1,Interval(Min(FailTS)-StartTS,'hh:mm:ss.fff')))<BR />&nbsp; &nbsp; &nbsp; &nbsp;Error:Error in expression:Nested aggregation not allowed<BR />How can we solve it?Any suggestion would be helpful<BR /><BR />Thank you<BR /><BR /><BR /><BR /></P> Wed, 23 Feb 2022 10:17:32 GMT Athira_K 2022-02-23T10:17:32Z https://community.qlik.com/t5/QlikView/Nested-Error/m-p/1896448#M1217560 <P>Hello,<BR />I have used 2 expressions in 2 charts.<BR />To calculate the sum of that expression I have tried the following expressions and they are causing following errors:<BR />1.=Sum(If(F=0,Interval(Max(StopTime)-StartTime,'hh:mm:ss.fff')))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;//In chart Im getting the correct column wo error<BR />&nbsp; &nbsp; &nbsp; &nbsp;Error:Error in expression:Nested aggregation not allowed<BR />2.=Min(If(Fail=1,Interval(Min(FailTS)-StartTS,'hh:mm:ss.fff')))<BR />&nbsp; &nbsp; &nbsp; &nbsp;Error:Error in expression:Nested aggregation not allowed<BR />How can we solve it?Any suggestion would be helpful<BR /><BR />Thank you<BR /><BR /><BR /><BR /></P> Wed, 23 Feb 2022 10:17:32 GMT https://community.qlik.com/t5/QlikView/Nested-Error/m-p/1896448#M1217560 Athira_K 2022-02-23T10:17:32Z https://community.qlik.com/t5/QlikView/Nested-Error/m-p/1896759#M1217576 <P><A href="https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/nested-aggregations.htm" target="_blank">https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/nested-aggregations.htm</A></P> <P><A href="https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/nested-aggregations-aggregation-function.htm" target="_blank">https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/nested-aggregations-aggregation-function.htm</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 23 Feb 2022 19:23:23 GMT https://community.qlik.com/t5/QlikView/Nested-Error/m-p/1896759#M1217576 MarcoWedel 2022-02-23T19:23:23Z