topic Re: SUM / IF in expressions statement in QlikView https://community.qlik.com/t5/QlikView/SUM-IF-in-expressions-statement/m-p/405593#M150940 <HTML><HEAD></HEAD><BODY><P>You have to make sure that your date fields have the same format.</P><P>Contract Value would be the field you want to calculate </P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">sum({$&lt;month.budget.date = {"monthsig"}, year.budget.date = {"yearsig"}&gt;} </SPAN><A _jive_internal="true" href="https://community.qlik.com/TCV Target ($)" style="background-color: #ffffff; font-size: 12.727272033691406px; color: #007fc0; font-family: Arial;">[Contract Value</A>]<SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">)</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Tue, 05 Feb 2013 18:29:25 GMT chematos 2013-02-05T18:29:25Z SUM / IF in expressions statement https://community.qlik.com/t5/QlikView/SUM-IF-in-expressions-statement/m-p/405592#M150939 <HTML><HEAD></HEAD><BODY><P>I'm new to CV and trying to sum a value if another 2 values are meet, it does not work !!! </P><P></P><P>My formula is as follow </P><P></P><P>sum({$&lt;month.budget.date = monthsig, year.budget.date = yearsig&gt;} <A _jive_internal="true" href="TCV Target ($)">SUM in expressios on statement</A>)</P><P></P><P>which translate in if my budget dates (month.budget.date&nbsp; and year.budget.date ) match by signature date (monthsig and yearsig) , then I would like top plot the TCV (contract value) </P></BODY></HTML> Tue, 05 Feb 2013 16:28:42 GMT https://community.qlik.com/t5/QlikView/SUM-IF-in-expressions-statement/m-p/405592#M150939 2013-02-05T16:28:42Z Re: SUM / IF in expressions statement https://community.qlik.com/t5/QlikView/SUM-IF-in-expressions-statement/m-p/405593#M150940 <HTML><HEAD></HEAD><BODY><P>You have to make sure that your date fields have the same format.</P><P>Contract Value would be the field you want to calculate </P><P></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">sum({$&lt;month.budget.date = {"monthsig"}, year.budget.date = {"yearsig"}&gt;} </SPAN><A _jive_internal="true" href="https://community.qlik.com/TCV Target ($)" style="background-color: #ffffff; font-size: 12.727272033691406px; color: #007fc0; font-family: Arial;">[Contract Value</A>]<SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;">)</SPAN></P><P><SPAN style="color: #737373; font-family: Arial; font-size: 12.727272033691406px; background-color: #ffffff;"><BR /></SPAN></P></BODY></HTML> Tue, 05 Feb 2013 18:29:25 GMT https://community.qlik.com/t5/QlikView/SUM-IF-in-expressions-statement/m-p/405593#M150940 chematos 2013-02-05T18:29:25Z