topic Re: Input field-Input sum - error in expression in QlikView https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942098#M951008 <HTML><HEAD></HEAD><BODY><P>The inputfield must be as inputfield declared before it is loaded.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 03 Dec 2015 12:48:26 GMT marcus_sommer 2015-12-03T12:48:26Z Input field-Input sum - error in expression https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942097#M951007 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I am stuck with inputfield and inputsum in my pivot table.</P><P></P><P>1) I have a data extractor which converts my source file into qvds. I have extracted data from excel files</P><P>2) I have a data model application which pulls data from the QVDs generated above. In one table, I am hardcoding value '3' as OutputQty.</P><P>3)&nbsp; I have binary loaded the above data model into another application to use it for dashboard development</P><P>4)&nbsp; In dashboard development application, i am declaring 'OutputQty' field as INPUTFIELD</P><P>5) When i call this in my pivot table expression as&nbsp; Inputsum(OutputQty), i am getting erorr in expression. Also, the values are not displayed as expected in the table.</P><P></P><P>I also tried declaring the field as Inputfield in Datamodel layer, even then error persists.</P><P></P><P>Basically the requirement is to pull value of OutputQty field from excel and populate in report. It should also be an editable field so user can change it later.</P><P></P><P>I am stuck with this and urgently need solution for it for my project. Kindly help asap.</P></BODY></HTML> Thu, 03 Dec 2015 02:15:46 GMT https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942097#M951007 2015-12-03T02:15:46Z Re: Input field-Input sum - error in expression https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942098#M951008 <HTML><HEAD></HEAD><BODY><P>The inputfield must be as inputfield declared before it is loaded.</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 03 Dec 2015 12:48:26 GMT https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942098#M951008 marcus_sommer 2015-12-03T12:48:26Z Re: Input field-Input sum - error in expression https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942099#M951009 <HTML><HEAD></HEAD><BODY><P>Hi I have declared it as input field before loading as well. Still doesn't work for me. I declared it in data model application. Is it possible to use it as input field in dashboard application, after pulling data model app as binary load into dashboard app?</P></BODY></HTML> Fri, 04 Dec 2015 01:22:10 GMT https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942099#M951009 2015-12-04T01:22:10Z Re: Input field-Input sum - error in expression https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942100#M951010 <HTML><HEAD></HEAD><BODY><P>A binary load pulled the datamodel 1:1 from the source. Therefore the inputfield-feature should work. You could test it within your datamodel-app with a small tablebox and you will see if this field is editable or not.</P><P></P><P>Further you need to make sure that both field-statements (inputfield-statement and the field within your load) is identically - qv is case-sensitive and Inputfield &lt;&gt; InputField.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 04 Dec 2015 17:59:52 GMT https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942100#M951010 marcus_sommer 2015-12-04T17:59:52Z Re: Input field-Input sum - error in expression https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942101#M951011 <HTML><HEAD></HEAD><BODY><P>Thanks. I tried it and it works fine now.</P></BODY></HTML> Mon, 07 Dec 2015 14:41:19 GMT https://community.qlik.com/t5/QlikView/Input-field-Input-sum-error-in-expression/m-p/942101#M951011 2015-12-07T14:41:19Z