topic Re: Set Analysis not working in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/485523#M482436 <HTML><HEAD></HEAD><BODY><P>It is not possible to have an aggregation function inside another aggregation function here. It has nothing to do with the Set analysis.</P><P></P><P>It looks as if you are trying to calculate a percentage, No of Responses over No of Calls\Clicks. Then you should have one aggregation function divided by another, e.g. Sum(Responses)/Sum("Calls\Clicks")</P><P></P><P>HIC</P></BODY></HTML> Mon, 12 Aug 2013 15:57:34 GMT hic 2013-08-12T15:57:34Z Set Analysis not working https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/485522#M482435 <HTML><HEAD></HEAD><BODY><P>I am trying to use set analysis (example below) but all I am getting is '-' in the table.</P><P></P><P>Sum({&lt;Year={2012,2013,2014}&gt;} if(Planner.Metric='Responses',Planner.Forecast)/sum({&lt;Planner.Metric={'Calls\Clicks'}&gt;} Planner.Forecast))</P><P></P><P>Any help would be appriciated.</P><P></P></BODY></HTML> Mon, 12 Aug 2013 15:36:29 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/485522#M482435 2013-08-12T15:36:29Z Re: Set Analysis not working https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/485523#M482436 <HTML><HEAD></HEAD><BODY><P>It is not possible to have an aggregation function inside another aggregation function here. It has nothing to do with the Set analysis.</P><P></P><P>It looks as if you are trying to calculate a percentage, No of Responses over No of Calls\Clicks. Then you should have one aggregation function divided by another, e.g. Sum(Responses)/Sum("Calls\Clicks")</P><P></P><P>HIC</P></BODY></HTML> Mon, 12 Aug 2013 15:57:34 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/485523#M482436 hic 2013-08-12T15:57:34Z