topic Re: avg Last value per client in the selection in QlikView https://community.qlik.com/t5/QlikView/avg-Last-value-per-client-in-the-selection/m-p/779951#M276396 <HTML><HEAD></HEAD><BODY><P>avg(aggr(firstsortedvalue(value,-date),Client))</P></BODY></HTML> Tue, 13 Jan 2015 12:25:55 GMT Gysbert_Wassenaar 2015-01-13T12:25:55Z avg Last value per client in the selection https://community.qlik.com/t5/QlikView/avg-Last-value-per-client-in-the-selection/m-p/779950#M276395 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>how can i get the average of the latest value per client per selection?</P><P>In the case below the value will be<SPAN style="font-size: 14pt;"> <STRONG>3,333</STRONG></SPAN> if I have the selection: feb 2014</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;transparent&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 229px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl65" height="17" style="width: 48pt; height: 12.75pt; background-color: transparent;" width="64">Client</TD><TD class="xl65" style="width: 53pt; background-color: transparent;" width="71">date</TD><TD class="xl65" style="width: 48pt; background-color: transparent;" width="64">value</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">1</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-01-01</TD><TD align="right" class="xl65" style="background-color: transparent;">2</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">1</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-02-01</TD><TD align="right" class="xl65" style="background-color: transparent;">2</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl67" height="17" style="height: 12.75pt; background-color: yellow;">1</TD><TD align="right" class="xl68" style="background-color: yellow;">2014-02-15</TD><TD align="right" class="xl67" style="background-color: yellow;">3</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">1</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-03-08</TD><TD align="right" class="xl65" style="background-color: transparent;">4</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">1</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-09-01</TD><TD align="right" class="xl65" style="background-color: transparent;">2</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">1</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-10-10</TD><TD align="right" class="xl65" style="background-color: transparent;">3</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">3</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-01-01</TD><TD align="right" class="xl65" style="background-color: transparent;">1</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">3</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-02-01</TD><TD align="right" class="xl65" style="background-color: transparent;">5</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl67" height="17" style="height: 12.75pt; background-color: yellow;">3</TD><TD align="right" class="xl68" style="background-color: yellow;">2014-02-15</TD><TD align="right" class="xl67" style="background-color: yellow;">4</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">3</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-03-08</TD><TD align="right" class="xl65" style="background-color: transparent;">2</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">3</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-09-01</TD><TD align="right" class="xl65" style="background-color: transparent;">3</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">3</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-10-10</TD><TD align="right" class="xl65" style="background-color: transparent;">1</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">3</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-09-01</TD><TD align="right" class="xl65" style="background-color: transparent;">4</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">3</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-10-10</TD><TD align="right" class="xl65" style="background-color: transparent;">2</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl67" height="17" style="height: 12.75pt; background-color: yellow;">4</TD><TD align="right" class="xl68" style="background-color: yellow;">2014-02-08</TD><TD align="right" class="xl67" style="background-color: yellow;">3</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">4</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-09-01</TD><TD align="right" class="xl65" style="background-color: transparent;">1</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">4</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-10-10</TD><TD align="right" class="xl65" style="background-color: transparent;">4</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">4</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-09-01</TD><TD align="right" class="xl65" style="background-color: transparent;">5</TD></TR><TR style="height: 12.75pt;"><TD align="right" class="xl65" height="17" style="height: 12.75pt; background-color: transparent;">4</TD><TD align="right" class="xl66" style="background-color: transparent;">2014-10-10</TD><TD align="right" class="xl65" style="background-color: transparent;">1</TD></TR></TBODY></TABLE><P><BR /> </P></BODY></HTML> Tue, 13 Jan 2015 11:55:40 GMT https://community.qlik.com/t5/QlikView/avg-Last-value-per-client-in-the-selection/m-p/779950#M276395 2015-01-13T11:55:40Z Re: avg Last value per client in the selection https://community.qlik.com/t5/QlikView/avg-Last-value-per-client-in-the-selection/m-p/779951#M276396 <HTML><HEAD></HEAD><BODY><P>avg(aggr(firstsortedvalue(value,-date),Client))</P></BODY></HTML> Tue, 13 Jan 2015 12:25:55 GMT https://community.qlik.com/t5/QlikView/avg-Last-value-per-client-in-the-selection/m-p/779951#M276396 Gysbert_Wassenaar 2015-01-13T12:25:55Z Re: avg Last value per client in the selection https://community.qlik.com/t5/QlikView/avg-Last-value-per-client-in-the-selection/m-p/779952#M276397 <HTML><HEAD></HEAD><BODY><P>Thank you Gysbert! It solved the problem!</P></BODY></HTML> Tue, 13 Jan 2015 12:37:28 GMT https://community.qlik.com/t5/QlikView/avg-Last-value-per-client-in-the-selection/m-p/779952#M276397 2015-01-13T12:37:28Z