topic Re: Aggregation functions in QlikView https://community.qlik.com/t5/QlikView/Aggregation-functions/m-p/624662#M229777 <HTML><HEAD></HEAD><BODY><P>Maybe something like:</P><P></P><P>firstsortedvalue(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">YYYYMM</SPAN>, -<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">aggr(sum(Sales), YYYYMM)</SPAN>)</P><P></P><P>Hope this helps!</P></BODY></HTML> Wed, 26 Mar 2014 13:12:57 GMT jerem1234 2014-03-26T13:12:57Z Aggregation functions https://community.qlik.com/t5/QlikView/Aggregation-functions/m-p/624661#M229776 <HTML><HEAD></HEAD><BODY><P>Hello: </P><P></P><P>I have this expresion </P><P></P><P>= max(aggr(sum(Sales), YYYYMM)</P><P></P><P>and I get the bigger sales amount grouped by month (YYYYMM); now I need a second expression to get the asociated YYYYMM value.</P><P></P><P>Please, could you help me?</P><P></P><P>Thank you</P><P>Joaquín</P></BODY></HTML> Wed, 26 Mar 2014 12:38:37 GMT https://community.qlik.com/t5/QlikView/Aggregation-functions/m-p/624661#M229776 Joaquin_Lazaro 2014-03-26T12:38:37Z Re: Aggregation functions https://community.qlik.com/t5/QlikView/Aggregation-functions/m-p/624662#M229777 <HTML><HEAD></HEAD><BODY><P>Maybe something like:</P><P></P><P>firstsortedvalue(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">YYYYMM</SPAN>, -<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12.727272033691406px;">aggr(sum(Sales), YYYYMM)</SPAN>)</P><P></P><P>Hope this helps!</P></BODY></HTML> Wed, 26 Mar 2014 13:12:57 GMT https://community.qlik.com/t5/QlikView/Aggregation-functions/m-p/624662#M229777 jerem1234 2014-03-26T13:12:57Z Re: Aggregation functions https://community.qlik.com/t5/QlikView/Aggregation-functions/m-p/624663#M229778 <HTML><HEAD></HEAD><BODY><P>Hi <A _jive_internal="true" data-avatarid="1008" data-externalid="" data-online="false" data-presence="null" data-userid="114213" data-username="jerem1234" href="https://community.qlik.com/people/jerem1234" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f6f6f6;">jerem1234</A></P><P></P><P>This works fine.</P><P></P><P>Thank you</P></BODY></HTML> Thu, 27 Mar 2014 07:35:41 GMT https://community.qlik.com/t5/QlikView/Aggregation-functions/m-p/624663#M229778 Joaquin_Lazaro 2014-03-27T07:35:41Z