topic explanation of expression in App Development https://community.qlik.com/t5/App-Development/explanation-of-expression/m-p/33487#M2231 <HTML><HEAD></HEAD><BODY><P>can anybody help to explain this </P><P></P><P>sum({&lt;Date = {"&gt;=$(=vQBack)&lt;=$(=vCFinal)"},EX.EType={'GE'},[EX.IType]={'PNC'}&gt;}Balance)</P><P>+</P><P>sum({&lt;Date = {"&gt;=$(=vQBack)&lt;=$(=vCFinal)"},EX.EType={'TAllocated'},[EX.IType]={'PNC'}&gt;}Balance) * sum({&lt;[EType] = {'GE'}&gt;}Data)</P></BODY></HTML> Sat, 16 Nov 2024 08:19:53 GMT capriconuser 2024-11-16T08:19:53Z explanation of expression https://community.qlik.com/t5/App-Development/explanation-of-expression/m-p/33487#M2231 <HTML><HEAD></HEAD><BODY><P>can anybody help to explain this </P><P></P><P>sum({&lt;Date = {"&gt;=$(=vQBack)&lt;=$(=vCFinal)"},EX.EType={'GE'},[EX.IType]={'PNC'}&gt;}Balance)</P><P>+</P><P>sum({&lt;Date = {"&gt;=$(=vQBack)&lt;=$(=vCFinal)"},EX.EType={'TAllocated'},[EX.IType]={'PNC'}&gt;}Balance) * sum({&lt;[EType] = {'GE'}&gt;}Data)</P></BODY></HTML> Sat, 16 Nov 2024 08:19:53 GMT https://community.qlik.com/t5/App-Development/explanation-of-expression/m-p/33487#M2231 capriconuser 2024-11-16T08:19:53Z Re: explanation of expression https://community.qlik.com/t5/App-Development/explanation-of-expression/m-p/33488#M2232 <HTML><HEAD></HEAD><BODY><P>Sum balances where </P><UL><LI>Date between vQBack and vCFinal (probably variables) </LI><LI>EX.EType = 'GE'</LI><LI><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">EX.IType = 'PNC'</SPAN></LI></UL><P>And Add to</P><P>&nbsp;&nbsp;&nbsp;&nbsp; Sum balances where</P><UL><UL><LI>Date between vQBack and vCFinal (probably variables) </LI><LI>EX.EType = 'TAllocated'</LI><LI><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">EX.IType = 'PNC'</SPAN></LI></UL></UL><P>&nbsp;&nbsp;&nbsp;&nbsp; Multiplied by Sum of [Data] where</P><UL><UL><LI>&nbsp;&nbsp; EType&nbsp; = 'GE'</LI></UL></UL></BODY></HTML> Mon, 30 Apr 2018 07:02:23 GMT https://community.qlik.com/t5/App-Development/explanation-of-expression/m-p/33488#M2232 jonathandienst 2018-04-30T07:02:23Z