topic Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/589712#M682533 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I am using the following expression. The results are correct.</P><P></P><P>Sum($(=Only(AreaThisYear)))</P><P></P><P>I want to add some conditions and add it to the set analysis expression as below but not getting the desired results. </P><P></P><P>=if($(vTodaysYear)=Right(vSelectStartDate,4) AND $(vTodaysYear)=Right(vSelectEndDate,4) ,</P><P>sum({&lt;AreaMonthYear = {"&gt;=$(vSelectStartDateMY)&lt;=$(vSelectEndDateMY)"},<SPAN style="font-size: 10pt; line-height: 1.5em;">Year={'$(vTodaysFYear)'}&gt;} <SPAN style="color: #ffff00;"><STRONG style="color: #3366ff;">$(=Only(AreaThisYear))</STRONG></SPAN>))</SPAN></P><P></P><P>Kindly suggest the solution. Can we use Sum along with only in the set analysis. </P><P></P><P>Regards,</P><P>Alvin</P></BODY></HTML> Tue, 18 Mar 2014 14:53:51 GMT alvinford 2014-03-18T14:53:51Z Set Analysis https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/589712#M682533 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I am using the following expression. The results are correct.</P><P></P><P>Sum($(=Only(AreaThisYear)))</P><P></P><P>I want to add some conditions and add it to the set analysis expression as below but not getting the desired results. </P><P></P><P>=if($(vTodaysYear)=Right(vSelectStartDate,4) AND $(vTodaysYear)=Right(vSelectEndDate,4) ,</P><P>sum({&lt;AreaMonthYear = {"&gt;=$(vSelectStartDateMY)&lt;=$(vSelectEndDateMY)"},<SPAN style="font-size: 10pt; line-height: 1.5em;">Year={'$(vTodaysFYear)'}&gt;} <SPAN style="color: #ffff00;"><STRONG style="color: #3366ff;">$(=Only(AreaThisYear))</STRONG></SPAN>))</SPAN></P><P></P><P>Kindly suggest the solution. Can we use Sum along with only in the set analysis. </P><P></P><P>Regards,</P><P>Alvin</P></BODY></HTML> Tue, 18 Mar 2014 14:53:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis/m-p/589712#M682533 alvinford 2014-03-18T14:53:51Z