topic Error in expression: Inputsum must have input field as parameter in QlikView

Error in expression: Inputsum must have input field as parameter

Fri, 11 Mar 2016 15:36:31 GMT

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

Re: Error in expression: Inputsum must have input field as parameter

Gysbert_Wassenaar — Fri, 11 Mar 2016 15:53:06 GMT

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

Re: Error in expression: Inputsum must have input field as parameter

Fri, 11 Mar 2016 15:57:53 GMT

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

Re: Error in expression: Inputsum must have input field as parameter

Gysbert_Wassenaar — Fri, 11 Mar 2016 17:13:46 GMT

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.

Re: Error in expression: Inputsum must have input field as parameter

muratakkemik — Sat, 09 May 2020 16:17:05 GMT

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