topic Re: AGGR problem in QlikView https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/751145#M267828 <HTML><HEAD></HEAD><BODY><P>There are syntax errors in the expression you posted but i couldn't tell you what the right expression is without some kind of test data or qvw to work with.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 01 Dec 2014 16:38:32 GMT JonnyPoole 2014-12-01T16:38:32Z AGGR problem https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/751144#M267827 <HTML><HEAD></HEAD><BODY><P>Need a little help with this.&nbsp; What am I missing?&nbsp; Trying to get the average number of days it takes to win a quote.&nbsp; Them compare it to the overall company. Thanks Avg({} total aggr(sum({} Num_ApptSchEnd_Date) -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; aggr(sum({} Num_Opportunity_Created_On) /&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; count({}DISTINCT(ProposalNo),L3Desc)</P></BODY></HTML> Mon, 01 Dec 2014 16:26:53 GMT https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/751144#M267827 tmumaw 2014-12-01T16:26:53Z Re: AGGR problem https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/751145#M267828 <HTML><HEAD></HEAD><BODY><P>There are syntax errors in the expression you posted but i couldn't tell you what the right expression is without some kind of test data or qvw to work with.</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P></BODY></HTML> Mon, 01 Dec 2014 16:38:32 GMT https://community.qlik.com/t5/QlikView/AGGR-problem/m-p/751145#M267828 JonnyPoole 2014-12-01T16:38:32Z