topic Conditional aggregate in QlikView https://community.qlik.com/t5/QlikView/Conditional-aggregate/m-p/577055#M477332 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the following expression which works fine: "=Sum(Aggr(FirstSortedValue([Loan($)],-Date),[Grower No.])) ". In my data, I have a column with "Year" in it. How can I tweak the expression so that it only sums up where Year = 2014 for example. I am getting myself in a twist trying to use the if function here.</P><P></P><P>Thank you</P><P></P><P>Herbert</P></BODY></HTML> Tue, 29 Apr 2014 17:44:02 GMT 2014-04-29T17:44:02Z Conditional aggregate https://community.qlik.com/t5/QlikView/Conditional-aggregate/m-p/577055#M477332 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have the following expression which works fine: "=Sum(Aggr(FirstSortedValue([Loan($)],-Date),[Grower No.])) ". In my data, I have a column with "Year" in it. How can I tweak the expression so that it only sums up where Year = 2014 for example. I am getting myself in a twist trying to use the if function here.</P><P></P><P>Thank you</P><P></P><P>Herbert</P></BODY></HTML> Tue, 29 Apr 2014 17:44:02 GMT https://community.qlik.com/t5/QlikView/Conditional-aggregate/m-p/577055#M477332 2014-04-29T17:44:02Z Re: Conditional aggregate https://community.qlik.com/t5/QlikView/Conditional-aggregate/m-p/577056#M477333 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Sum({&lt;Year = {2014}&gt;} Aggr(FirstSortedValue(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">{&lt;Year = {2014}&gt;}</SPAN> [Loan($)],-Date),[Grower No.])) </SPAN></P></BODY></HTML> Tue, 29 Apr 2014 17:50:24 GMT https://community.qlik.com/t5/QlikView/Conditional-aggregate/m-p/577056#M477333 swuehl 2014-04-29T17:50:24Z