topic SUM Error in Expression in QlikView https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395622#M1161494 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13542937063696234" jivemacro_uid="_13542937063696234"><P></P><P></P></PRE><P>Hi QLIKCommunity:</P><P></P><P>I need to sum ESvnatural field, if 2 conditions like below;</P><P></P><P style="text-align: center;"><STRONG>SUM(IF((ESidproducto=1)and (EStmovimiento=S)),ESvnatural</STRONG>)</P><P></P><P style="text-align: center;">But I get Error in expression,, please you help on this...Tk in advanced</P><P></P><P style="text-align: center;">James Marines</P></BODY></HTML> Fri, 30 Nov 2012 16:46:50 GMT jmarinesc 2012-11-30T16:46:50Z SUM Error in Expression https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395622#M1161494 <HTML><HEAD></HEAD><BODY><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13542937063696234" jivemacro_uid="_13542937063696234"><P></P><P></P></PRE><P>Hi QLIKCommunity:</P><P></P><P>I need to sum ESvnatural field, if 2 conditions like below;</P><P></P><P style="text-align: center;"><STRONG>SUM(IF((ESidproducto=1)and (EStmovimiento=S)),ESvnatural</STRONG>)</P><P></P><P style="text-align: center;">But I get Error in expression,, please you help on this...Tk in advanced</P><P></P><P style="text-align: center;">James Marines</P></BODY></HTML> Fri, 30 Nov 2012 16:46:50 GMT https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395622#M1161494 jmarinesc 2012-11-30T16:46:50Z Re: SUM Error in Expression https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395623#M1161495 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P> Try like this</P><P></P><P>=Sum({&lt;<STRONG>ESidproducto={1},</STRONG><STRONG>EStmovimiento={'S'}</STRONG>&gt;}<STRONG>ESvnatural)</STRONG></P><P></P><P><STRONG>Hope it helps<BR /></STRONG></P></BODY></HTML> Fri, 30 Nov 2012 16:50:05 GMT https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395623#M1161495 MayilVahanan 2012-11-30T16:50:05Z Re: SUM Error in Expression https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395624#M1161496 <HTML><HEAD></HEAD><BODY><P>May be you should use like this</P><P><STRONG style="background-color: #ffffff; color: #737373; font-family: Arial; text-align: center;">SUM(IF((ESidproducto=1)and (EStmovimiento=S),ESvnatural)</STRONG><SPAN style="color: #737373; font-family: Arial; text-align: center; background-color: #ffffff;">)</SPAN></P><P></P><P>You can go with set analysis like</P><P><STRONG>SUM({&lt;<STRONG style="background-color: #ffffff; color: #737373; font-family: Arial; text-align: center;">ESidproducto={1},<STRONG style="background-color: #ffffff; color: #737373; font-family: Arial; text-align: center;">EStmovimiento={'S'}</STRONG></STRONG>&gt;} <STRONG style="background-color: #ffffff; color: #737373; font-family: Arial; text-align: center;">ESvnatural</STRONG>)</STRONG></P></BODY></HTML> Fri, 30 Nov 2012 16:50:30 GMT https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395624#M1161496 CELAMBARASAN 2012-11-30T16:50:30Z Re: SUM Error in Expression https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395625#M1161497 <HTML><HEAD></HEAD><BODY><P>Great!&nbsp;&nbsp; It works , Thanks a lot .....I am very glad for all this strong QlikSupport.....I really appreciate it.</P><P></P><P>Jaime Marines</P></BODY></HTML> Fri, 30 Nov 2012 16:57:30 GMT https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395625#M1161497 jmarinesc 2012-11-30T16:57:30Z Re: SUM Error in Expression https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395626#M1161498 <HTML><HEAD></HEAD><BODY><P>Great!&nbsp;&nbsp; It works , Thanks a lot .....I am very glad for all this strong QlikSupport.....I really appreciate it.</P><P></P><P>Jaime Marines</P></BODY></HTML> Fri, 30 Nov 2012 16:58:17 GMT https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395626#M1161498 jmarinesc 2012-11-30T16:58:17Z Re: SUM Error in Expression https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395627#M1161499 <HTML><HEAD></HEAD><BODY><P>Great!&nbsp;&nbsp; It works , Thanks a lot .....I am very glad for all this strong QlikSupport.....I really appreciate it.</P><P></P><P>Jaime Marines</P></BODY></HTML> Fri, 30 Nov 2012 16:58:46 GMT https://community.qlik.com/t5/QlikView/SUM-Error-in-Expression/m-p/395627#M1161499 jmarinesc 2012-11-30T16:58:46Z