topic Re: Expression Aggregation in QlikView https://community.qlik.com/t5/QlikView/Expression-Aggregation/m-p/1025266#M931961 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P><STRONG>=Sum(Aggr(SUM([OD + POS FOR &gt;180])+(IF(SUM(AGGR(NODISTINCT SUM([Total no. of Cases]),[Proposal Link Key]))&gt;0,SUM([Loss On Settlement]),0)), Year, [Proposal Link Key]))</STRONG></P></BODY></HTML> Tue, 08 Mar 2016 10:39:55 GMT sunny_talwar 2016-03-08T10:39:55Z Expression Aggregation https://community.qlik.com/t5/QlikView/Expression-Aggregation/m-p/1025265#M931960 <HTML><HEAD></HEAD><BODY><P>Dear All</P><P></P><P>By default, the expression shows wrong result in Subheader Total.</P><P>But when I select Proposal Link Key than it shows Correct Amount in Subtotal Header.</P><P></P><P></P><P>The problem is with Loss on Settlement Amount. I am not able to aggregate it in Expression.</P><P>Kindly provide solution.....???</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Expression-Aggregation/m-p/1025265#M931960 2020-11-25T16:16:04Z Re: Expression Aggregation https://community.qlik.com/t5/QlikView/Expression-Aggregation/m-p/1025266#M931961 <HTML><HEAD></HEAD><BODY><P>Try this expression:</P><P><STRONG>=Sum(Aggr(SUM([OD + POS FOR &gt;180])+(IF(SUM(AGGR(NODISTINCT SUM([Total no. of Cases]),[Proposal Link Key]))&gt;0,SUM([Loss On Settlement]),0)), Year, [Proposal Link Key]))</STRONG></P></BODY></HTML> Tue, 08 Mar 2016 10:39:55 GMT https://community.qlik.com/t5/QlikView/Expression-Aggregation/m-p/1025266#M931961 sunny_talwar 2016-03-08T10:39:55Z Re: Expression Aggregation https://community.qlik.com/t5/QlikView/Expression-Aggregation/m-p/1025267#M931962 <HTML><HEAD></HEAD><BODY><P>Thank You Sir.</P><P>It is working Perfectly.</P></BODY></HTML> Tue, 08 Mar 2016 10:51:30 GMT https://community.qlik.com/t5/QlikView/Expression-Aggregation/m-p/1025267#M931962 2016-03-08T10:51:30Z