topic inputsum in an expression in QlikView https://community.qlik.com/t5/QlikView/inputsum-in-an-expression/m-p/213839#M67488 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P>I have a question to put on. Although, I have defined the field '<EM>value</EM>' as inputfield,</P><P>I use an expression by entering the following code:</P><P><STRONG>inputsum(if (FISCPRD=YEAR and MONTH&lt;=VPeriod ,(value))) / 2</STRONG>, which is not editable...</P><P>If I remove the division by 2, the expression is editable.</P><P>Am I doing something wrong or QlikView does not support calculations in expressions by using the aggregate function 'inputsum'?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 12 Oct 2009 20:50:15 GMT 2009-10-12T20:50:15Z inputsum in an expression https://community.qlik.com/t5/QlikView/inputsum-in-an-expression/m-p/213839#M67488 <HTML><HEAD></HEAD><BODY><P>Hi to all,</P><P>I have a question to put on. Although, I have defined the field '<EM>value</EM>' as inputfield,</P><P>I use an expression by entering the following code:</P><P><STRONG>inputsum(if (FISCPRD=YEAR and MONTH&lt;=VPeriod ,(value))) / 2</STRONG>, which is not editable...</P><P>If I remove the division by 2, the expression is editable.</P><P>Am I doing something wrong or QlikView does not support calculations in expressions by using the aggregate function 'inputsum'?</P><P></P><P>Thanks!</P></BODY></HTML> Mon, 12 Oct 2009 20:50:15 GMT https://community.qlik.com/t5/QlikView/inputsum-in-an-expression/m-p/213839#M67488 2009-10-12T20:50:15Z