topic Problem in set analysis in QlikView https://community.qlik.com/t5/QlikView/Problem-in-set-analysis/m-p/404787#M150637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>sum(if ( AccType='Out' and num(Month)=<EM>vMonth</EM>, balance)) its working fine, how we write the given expression in set analysis.</P><P></P><P>Regards,</P><P></P><P>Zain.</P></BODY></HTML> Thu, 13 Sep 2012 11:34:55 GMT 2012-09-13T11:34:55Z Problem in set analysis https://community.qlik.com/t5/QlikView/Problem-in-set-analysis/m-p/404787#M150637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>sum(if ( AccType='Out' and num(Month)=<EM>vMonth</EM>, balance)) its working fine, how we write the given expression in set analysis.</P><P></P><P>Regards,</P><P></P><P>Zain.</P></BODY></HTML> Thu, 13 Sep 2012 11:34:55 GMT https://community.qlik.com/t5/QlikView/Problem-in-set-analysis/m-p/404787#M150637 2012-09-13T11:34:55Z Re: Problem in set analysis https://community.qlik.com/t5/QlikView/Problem-in-set-analysis/m-p/404788#M150638 <HTML><HEAD></HEAD><BODY><P>first thing u cant use function at left side of = in set,</P><P>rather than this ur expression can be</P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">sum({&lt;AccType={'Out'},Month={"=$(</SPAN><EM style="background-color: #eef4f9; font-size: 12px; color: #636363; font-family: Arial;">vMonth)"}</EM><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">, balance))</SPAN></P><P>hOPE THIS HELPS!!! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 13 Sep 2012 11:38:21 GMT https://community.qlik.com/t5/QlikView/Problem-in-set-analysis/m-p/404788#M150638 rajni_batra 2012-09-13T11:38:21Z Re: Problem in set analysis https://community.qlik.com/t5/QlikView/Problem-in-set-analysis/m-p/404789#M150639 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;"><BR /></SPAN></P><P>Thanks, Rajni batra</P></BODY></HTML> Thu, 13 Sep 2012 11:53:14 GMT https://community.qlik.com/t5/QlikView/Problem-in-set-analysis/m-p/404789#M150639 2012-09-13T11:53:14Z