topic Set Analysis with aggregate in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-aggregate/m-p/225896#M78161 <HTML><HEAD></HEAD><BODY><P>I am using an aggregation function in which i want to include set analysis for the previous year and am struggling a little bit. the expression which does not work is</P><P></P><P>=-sum( {$&lt;[Year-RCV] = {$(=Min([Year-RCV])-1)}&gt;} aggr([Transit Time] &gt;= ([Receipt Date] - [Ship Date]),[Doc. Number]))</P><P></P><P>am using the same set analysis to count in another expression and it works. the working expression is</P><P>=count({$&lt;[Year-RCV] = {$(=Min([Year-RCV])-1)}&gt;} distinct [Doc. Number])</P></BODY></HTML> Thu, 28 Jan 2010 18:33:54 GMT 2010-01-28T18:33:54Z Set Analysis with aggregate https://community.qlik.com/t5/QlikView/Set-Analysis-with-aggregate/m-p/225896#M78161 <HTML><HEAD></HEAD><BODY><P>I am using an aggregation function in which i want to include set analysis for the previous year and am struggling a little bit. the expression which does not work is</P><P></P><P>=-sum( {$&lt;[Year-RCV] = {$(=Min([Year-RCV])-1)}&gt;} aggr([Transit Time] &gt;= ([Receipt Date] - [Ship Date]),[Doc. Number]))</P><P></P><P>am using the same set analysis to count in another expression and it works. the working expression is</P><P>=count({$&lt;[Year-RCV] = {$(=Min([Year-RCV])-1)}&gt;} distinct [Doc. Number])</P></BODY></HTML> Thu, 28 Jan 2010 18:33:54 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-aggregate/m-p/225896#M78161 2010-01-28T18:33:54Z