topic r12 calculation Syntax in QlikView https://community.qlik.com/t5/QlikView/r12-calculation-Syntax/m-p/423989#M558975 <HTML><HEAD></HEAD><BODY><P>Hi i am trying to achieve the following <SPAN style="font-size: 10pt;">R12 Calculation starting from today. </SPAN></P><P>however my statement is not working.</P><P></P><P></P><P><SPAN style="font-size: 10pt;">i have one variable which is my Sales amount $(vNettoFsg) </SPAN></P><P><SPAN style="font-size: 10pt;">and vToday = today ()</SPAN></P><P></P><P></P><P>is my syntax wrong?</P><P></P><P>=sum({$&lt;(vToday -365))&gt;},$(vNettoFsg)</P></BODY></HTML> Thu, 30 May 2013 11:35:43 GMT 2013-05-30T11:35:43Z r12 calculation Syntax https://community.qlik.com/t5/QlikView/r12-calculation-Syntax/m-p/423989#M558975 <HTML><HEAD></HEAD><BODY><P>Hi i am trying to achieve the following <SPAN style="font-size: 10pt;">R12 Calculation starting from today. </SPAN></P><P>however my statement is not working.</P><P></P><P></P><P><SPAN style="font-size: 10pt;">i have one variable which is my Sales amount $(vNettoFsg) </SPAN></P><P><SPAN style="font-size: 10pt;">and vToday = today ()</SPAN></P><P></P><P></P><P>is my syntax wrong?</P><P></P><P>=sum({$&lt;(vToday -365))&gt;},$(vNettoFsg)</P></BODY></HTML> Thu, 30 May 2013 11:35:43 GMT https://community.qlik.com/t5/QlikView/r12-calculation-Syntax/m-p/423989#M558975 2013-05-30T11:35:43Z Re: r12 calculation Syntax https://community.qlik.com/t5/QlikView/r12-calculation-Syntax/m-p/423990#M558976 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>sum(if($(<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">vToday</SPAN>)-365,<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">$(vNettoFsg)</SPAN>))</P></BODY></HTML> Thu, 30 May 2013 11:41:08 GMT https://community.qlik.com/t5/QlikView/r12-calculation-Syntax/m-p/423990#M558976 er_mohit 2013-05-30T11:41:08Z