topic Re: Aggr Help? in QlikView https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511759#M191214 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp; Have a look at the application.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 23 Jul 2013 10:28:40 GMT kaushiknsolanki 2013-07-23T10:28:40Z Aggr Help? https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511758#M191213 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I am trying to use the Aggr function for this example. </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Group</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Transaction</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Paid</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Outstanding</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>a</TD><TD>1</TD><TD>0</TD><TD>10,000</TD></TR><TR><TD>1</TD><TD>a</TD><TD>2</TD><TD>1,000</TD><TD>9,000</TD></TR><TR><TD>1</TD><TD>a</TD><TD>3</TD><TD>8,000</TD><TD>1,000</TD></TR><TR><TD>1</TD><TD>a</TD><TD>4</TD><TD>250</TD><TD>750</TD></TR><TR><TD><SPAN style="color: #333333;">1</SPAN></TD><TD><SPAN style="color: #333333;">a</SPAN></TD><TD><SPAN style="color: #333333;">5</SPAN></TD><TD><SPAN style="color: #333333;">100</SPAN></TD><TD><STRONG style="color: #ff0000;">650</STRONG></TD></TR><TR><TD>1</TD><TD>b</TD><TD>6</TD><TD>0</TD><TD>12,000</TD></TR><TR><TD><SPAN style="color: #333333;">1</SPAN></TD><TD><SPAN style="color: #333333;">b</SPAN></TD><TD><SPAN style="color: #333333;">7</SPAN></TD><TD><SPAN style="color: #333333;">6,000</SPAN></TD><TD><STRONG style="color: #ff0000;">6,000</STRONG></TD></TR></TBODY></TABLE><P></P><P>What i am trying to find out is the total outstanding for each ID. In this example the Total for ID 1 would be the sum of the Latest Outstanding (Latest Transaction) per group and ID. Total outstanding for ID 1 would equal 6,650.</P><P></P><P>Could anyone explain to me how i would use the Aggr function to work this out. </P><P></P><P>Thanks in advance. </P><P></P><P>Kind regards, </P><P></P><P>Natalie </P></BODY></HTML> Tue, 23 Jul 2013 10:18:41 GMT https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511758#M191213 2013-07-23T10:18:41Z Re: Aggr Help? https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511759#M191214 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>&nbsp;&nbsp;&nbsp; Have a look at the application.</P><P></P><P>Regards,</P><P>Kaushik Solanki</P></BODY></HTML> Tue, 23 Jul 2013 10:28:40 GMT https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511759#M191214 kaushiknsolanki 2013-07-23T10:28:40Z Re: Aggr Help? https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511760#M191215 <HTML><HEAD></HEAD><BODY><P>Can u tell me ur table structure and all fields?</P><P></P><P>Regards,</P><P>kabilan K.</P></BODY></HTML> Tue, 23 Jul 2013 10:30:09 GMT https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511760#M191215 2013-07-23T10:30:09Z Re: Aggr Help? https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511761#M191216 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P>Thanks for your response. I'd ideally like to be able to do this in the chart so i am able to look back in time over different periods.</P><P>Is this possible? </P><P></P><P>Kind regards</P></BODY></HTML> Tue, 23 Jul 2013 10:44:11 GMT https://community.qlik.com/t5/QlikView/Aggr-Help/m-p/511761#M191216 2013-07-23T10:44:11Z