topic Re: Application Optimization help in QlikView https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171392#M380730 <HTML><HEAD></HEAD><BODY><P>Absolutely the first one, infact set analysis optimize execution.</P><P></P><P>I'm not sure that the second returns correct values...</P></BODY></HTML> Fri, 10 Jun 2016 15:17:26 GMT alexandros17 2016-06-10T15:17:26Z Application Optimization help https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171390#M380728 <HTML><HEAD></HEAD><BODY><P style="text-align: center;"><STRONG style="color: #000000;">Count({$&lt;[Disenrolled Indicator]={'Y'}&gt;}distinct([Recipient Identifier]))</STRONG></P><P style="text-align: center;"></P><P style="text-align: center;"><SPAN style="color: #000000;"><STRONG>or </STRONG></SPAN></P><P style="text-align: center;"></P><P style="text-align: center;"><STRONG style="color: #000000;">If(Disenrolled Indicator]='Y', Count([Recipient Identifier]))</STRONG></P><P style="text-align: center;"><STRONG style="color: #000000;"><BR /></STRONG></P><P style="text-align: center;"><STRONG style="color: #000000;"><BR /></STRONG></P><P style="text-align: left;"><STRONG style="color: #000000;">Which one of these expressions is better to use ?<BR /></STRONG></P></BODY></HTML> Fri, 10 Jun 2016 15:13:13 GMT https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171390#M380728 arusanah 2016-06-10T15:13:13Z Re: Application Optimization help https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171391#M380729 <HTML><HEAD></HEAD><BODY><P>Depends on where you are using it. But generally speaking, Set Analysis is more efficient compared to using if statement.</P></BODY></HTML> Fri, 10 Jun 2016 15:16:06 GMT https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171391#M380729 sunny_talwar 2016-06-10T15:16:06Z Re: Application Optimization help https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171392#M380730 <HTML><HEAD></HEAD><BODY><P>Absolutely the first one, infact set analysis optimize execution.</P><P></P><P>I'm not sure that the second returns correct values...</P></BODY></HTML> Fri, 10 Jun 2016 15:17:26 GMT https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171392#M380730 alexandros17 2016-06-10T15:17:26Z Re: Application Optimization help https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171393#M380731 <HTML><HEAD></HEAD><BODY><P>I'm using it in Dashboards</P></BODY></HTML> Fri, 10 Jun 2016 15:17:38 GMT https://community.qlik.com/t5/QlikView/Application-Optimization-help/m-p/1171393#M380731 arusanah 2016-06-10T15:17:38Z