Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in expression: Inputsum must have input field as parameter

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];


4 Replies
Gysbert_Wassenaar

As far as I know the input*** functions are not supposed to be used in the script, only in charts.


talk is cheap, supply exceeds demand
Not applicable
Author

The weird thing is, it seems like it is working in the chart!

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
muratakkemik
Contributor III
Contributor III

Dont use the table name

Normally we are writing script like;

TableName:

Load *, inputfield1;

Select.....

if you want use inputfield should be like

//TableName:

Inputfield inputfield1;

Load *, inputfield1;

Select.....

In the char tables you must use in expresion Inputsum (inputfield1)

then it will work. If you use tablename, it doesn't work!

fyi