Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
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];


3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

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

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
Highlighted
Not applicable

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

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

Highlighted
MVP & Luminary
MVP & Luminary

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

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