This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Can someone please help?!?! Getting the error above : Error in expression: Inputsum must have input field as parameter
**Non confidential data**
INPUTFIELD Input_Total; INPUTFIELD Input_Part7Col11; INPUTFIELD Input_Part6ACol21; INPUTFIELD Input_Part5Col18; INPUTFIELD Input_Part6BCol15; Table A LOAD *, RowNo() AS [Row Number]; LOAD *, [Line 1*.20] + Inputsum([Input_Part7Col11]) as [FieldA], Inputsum(Input_Part6ACol21)*1000 as [FieldB], Inputsum(Input_Part5Col18)*1000 as [FieldC], Inputsum(Input_Part6BCol15)*1000 as [FieldD]; LOAD *, Inputsum(Input_Total)*.2 as [Line 1*.20]; LOAD [Key1], [Key2], SUM([FieldE]) as [ABC], 0 as Input_Total, 0 as Input_Part7Col11, 0 as Input_Part6ACol21, 0 as Input_Part5Col18, 0 as Input_Part6BCol15 Resident Part8 Group by [Key1],[Key2];
As far as I know the input*** functions are not supposed to be used in the script, only in charts.
The weird thing is, it seems like it is working in the chart!
That sounds perfectly sensible to me. What I find weird is that you don't get an syntax error when you try to put it in your script code.
Dont use the table name
Normally we are writing script like;
Load *, inputfield1;
if you want use inputfield should be like
In the char tables you must use in expresion Inputsum (inputfield1)
then it will work. If you use tablename, it doesn't work!