https://community.qlik.com/t5/QlikView/Straight-Chart-Aggregating-Data/m-p/1541803#M457205 <P>This just seems to return the Credit Bill Number (not the summed up values shown in my 1st attachment)?</P><P>Just for clarification, I keep my 3 dimensions as: Bill Number, Bill Original BillNum, and Bill Replacement BillNum correct?</P> Fri, 08 Feb 2019 20:46:15 GMT benvatvandata 2019-02-08T20:46:15Z https://community.qlik.com/t5/QlikView/Straight-Chart-Aggregating-Data/m-p/1541147#M457203 <P>Hi,</P><P>I'm having trouble aggregating this data on one row (see attachment)... Bill Number 700077 is a credit (credit = 1) if that helps...</P><P>&nbsp;</P><P>Thanks,</P><P>Ben</P><P>&nbsp;</P> Sat, 16 Nov 2024 04:31:30 GMT https://community.qlik.com/t5/QlikView/Straight-Chart-Aggregating-Data/m-p/1541147#M457203 benvatvandata 2024-11-16T04:31:30Z https://community.qlik.com/t5/QlikView/Straight-Chart-Aggregating-Data/m-p/1541249#M457204 Like this?<BR />Firstsortedvalue(BillNo, -Aggr(Measure, dim1, dim2)) Thu, 07 Feb 2019 23:30:38 GMT https://community.qlik.com/t5/QlikView/Straight-Chart-Aggregating-Data/m-p/1541249#M457204 Anil_Babu_Samineni 2019-02-07T23:30:38Z https://community.qlik.com/t5/QlikView/Straight-Chart-Aggregating-Data/m-p/1541803#M457205 <P>This just seems to return the Credit Bill Number (not the summed up values shown in my 1st attachment)?</P><P>Just for clarification, I keep my 3 dimensions as: Bill Number, Bill Original BillNum, and Bill Replacement BillNum correct?</P> Fri, 08 Feb 2019 20:46:15 GMT https://community.qlik.com/t5/QlikView/Straight-Chart-Aggregating-Data/m-p/1541803#M457205 benvatvandata 2019-02-08T20:46:15Z