topic Re: Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/896661#M993188 <HTML><HEAD></HEAD><BODY><P>You can try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum({&lt;pool_name = {"=A<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ggr(Sum(opened)/Sum(sent), pool_name) &lt; 0.05"</SPAN>}&gt;} sent)</STRONG></SPAN></P></BODY></HTML> Tue, 07 Jul 2015 15:36:46 GMT sunny_talwar 2015-07-07T15:36:46Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/896660#M993187 <HTML><HEAD></HEAD><BODY><P>Please let me know, How to convert this expression using Set Analysis ?</P><P></P><P>=if(aggr(num(sum(opened)/sum(sent),'###'),pool_name)&lt;0.05,sum(sent))<BR /> </P><P><SPAN class="mce_paste_marker"></SPAN></P></BODY></HTML> Tue, 07 Jul 2015 10:27:39 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/896660#M993187 2015-07-07T10:27:39Z Re: Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/896661#M993188 <HTML><HEAD></HEAD><BODY><P>You can try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>=Sum({&lt;pool_name = {"=A<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ggr(Sum(opened)/Sum(sent), pool_name) &lt; 0.05"</SPAN>}&gt;} sent)</STRONG></SPAN></P></BODY></HTML> Tue, 07 Jul 2015 15:36:46 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/896661#M993188 sunny_talwar 2015-07-07T15:36:46Z