topic Re: sum(if( statement in QlikView https://community.qlik.com/t5/QlikView/sum-if-statement/m-p/1025705#M932056 <HTML><HEAD></HEAD><BODY><P>This?</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;[Speed(Lane 1)]={'&lt;= $(vSpeed_Limiter)'} , Speed = {'$(#vSpeed_Limiter)'}&gt;} [Averaged Emissions])* [Flow(Lane 1)])</SPAN></P></BODY></HTML> Tue, 08 Mar 2016 10:19:37 GMT tresB 2016-03-08T10:19:37Z sum(if( statement https://community.qlik.com/t5/QlikView/sum-if-statement/m-p/1025703#M932054 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>cany anyone see an issue with the below formula?</P><P></P><P></P><P>sum(if([Speed(Lane 1)]&lt;= vSpeed_Limiter ,only({$&lt; Speed = {'$(#vSpeed_Limiter)'}&gt;} [Averaged Emissions])* [Flow(Lane 1)]))</P><P></P><P>all of the individual components work the problem seems to be with the only section however standalone that works too.</P><P></P><P>thanks </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/sum-if-statement/m-p/1025703#M932054 samuel_brierley 2020-11-25T16:16:04Z Re: sum(if( statement https://community.qlik.com/t5/QlikView/sum-if-statement/m-p/1025704#M932055 <HTML><HEAD></HEAD><BODY><P>Can you try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">{$&lt; Speed = {'$(#vSpeed_Limiter)'}&gt;} I</SPAN>f([Speed(Lane 1)] &lt;= vSpeed_Limiter, [Averaged Emissions] * [Flow(Lane 1)]))</STRONG></SPAN></P></BODY></HTML> Tue, 08 Mar 2016 10:13:51 GMT https://community.qlik.com/t5/QlikView/sum-if-statement/m-p/1025704#M932055 sunny_talwar 2016-03-08T10:13:51Z Re: sum(if( statement https://community.qlik.com/t5/QlikView/sum-if-statement/m-p/1025705#M932056 <HTML><HEAD></HEAD><BODY><P>This?</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">sum({&lt;[Speed(Lane 1)]={'&lt;= $(vSpeed_Limiter)'} , Speed = {'$(#vSpeed_Limiter)'}&gt;} [Averaged Emissions])* [Flow(Lane 1)])</SPAN></P></BODY></HTML> Tue, 08 Mar 2016 10:19:37 GMT https://community.qlik.com/t5/QlikView/sum-if-statement/m-p/1025705#M932056 tresB 2016-03-08T10:19:37Z