topic Re: Error on Sum Expression Aging Report in QlikView https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32146#M777770 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use aggr function like below.</P><P></P><P>Sum(Aggr(If Statement....,DImension1,DImension2))</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 30 Apr 2018 09:11:06 GMT kaushiknsolanki 2018-04-30T09:11:06Z Error on Sum Expression Aging Report https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32143#M777767 <HTML><HEAD></HEAD><BODY><P><IMG alt="SUM Expression.png" class="jive-image image-1" src="/legacyfs/online/201056_SUM Expression.png" style="height: 461px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32143#M777767 Anonymous 2020-11-25T16:16:04Z Re: Error on Sum Expression Aging Report https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32144#M777768 <HTML><HEAD></HEAD><BODY><P>Set Analysis should be the solution. Try this ..</P><P>Sum({&lt;Age={"&gt;=0&lt;=30"}&gt;}OpenBalance)</P></BODY></HTML> Mon, 30 Apr 2018 03:14:15 GMT https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32144#M777768 Lisa_P 2018-04-30T03:14:15Z Re: Error on Sum Expression Aging Report https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32145#M777769 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Try like this:</SPAN></P><P></P><P>sum(if((Age&gt;0) and (Age&lt;=30),<SPAN style="font-size: 13.3333px;">OpenBalance,0))</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">or</SPAN></P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Sum({&lt;Age={"&gt;=0&lt;=30"}&gt;}OpenBalance)</P><P></P><P>Br,</P><P>KC</P></BODY></HTML> Mon, 30 Apr 2018 07:56:18 GMT https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32145#M777769 jyothish8807 2018-04-30T07:56:18Z Re: Error on Sum Expression Aging Report https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32146#M777770 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use aggr function like below.</P><P></P><P>Sum(Aggr(If Statement....,DImension1,DImension2))</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Mon, 30 Apr 2018 09:11:06 GMT https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32146#M777770 kaushiknsolanki 2018-04-30T09:11:06Z Re: Error on Sum Expression Aging Report https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32147#M777771 <HTML><HEAD></HEAD><BODY><P><IMG alt="DIMS.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/201089_DIMS.png" style="height: 481px; width: 620px;" /></P></BODY></HTML> Mon, 30 Apr 2018 09:14:22 GMT https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32147#M777771 Anonymous 2018-04-30T09:14:22Z Re: Error on Sum Expression Aging Report https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32148#M777772 <HTML><HEAD></HEAD><BODY><P>Age and OpenBalance are <STRONG>not fields</STRONG> in your data model. They look to be <STRONG>labels.</STRONG> And labels <STRONG>can't be aggregated</STRONG> (using sum() here). To get the same result from another column in aggregation function, you could rather use the same expression. If you could provide a sample app and explain expected output, it would be easier for us to help.</P></BODY></HTML> Mon, 30 Apr 2018 09:25:05 GMT https://community.qlik.com/t5/QlikView/Error-on-Sum-Expression-Aging-Report/m-p/32148#M777772 tresB 2018-04-30T09:25:05Z