topic Re: "Script Error": invalid expression in QlikView

"Script Error": invalid expression

wgonzalez — Fri, 28 Sep 2012 20:49:07 GMT

Hi,

Where could the invalid expression be in this script? I'm receiving the "script error" message while running the script. The error "Error: Invalid expression" is shown in the Script Execution Progess dialog box.

SUB

Headcount_SummaryHeadCountSumm:

LOAD EmpMonthYear as MonthYear,
BusinessUnit as [Business Unit],
DepartmentNo as [Department No],
DepartmentName as [Department Name],
WorkCenter as [Work Center],
PayGroup as [Pay Group],
sum(EmpRecordCtr) as Headcount,
NetWorkDays(MonthStart(min(MthSrt)),MonthEnd(max(MthEnd))) as
WorkingDays
Resident Employees
Group by EmpMonthYear, BusinessUnit,DepartmentName,WorkCenter,PayGroup;
/* Grouping is made according to EW Organization's hierarchy. */
ENDSUB /* Headcount_Summary */

Re: "Script Error": invalid expression

MayilVahanan — Fri, 28 Sep 2012 21:03:02 GMT

Please remove the sub and end sub in your script..

And add DepartmentNo,workingDays, MthSrt,MthEnd in group by..

Hope that helps

Re: "Script Error": invalid expression

wgonzalez — Fri, 28 Sep 2012 21:17:50 GMT

I'm calling the subroutine from another tab.

Re: "Script Error": invalid expression

MayilVahanan — Fri, 28 Sep 2012 21:32:23 GMT

Did you add

DepartmentNo,workingDays, MthSrt,MthEnd in group by..

Re: "Script Error": invalid expression

jonathandienst — Fri, 28 Sep 2012 21:50:51 GMT

If you use a group by statement, every field in the LOAD or SELECT must either be in an aggregate expression (like Sum or Max) or in the group by expression. As the previous post states, you have omitted some fields from the group by.

Regards

Jonathan

Re: "Script Error": invalid expression

bdiamante — Tue, 01 Jul 2014 15:12:07 GMT

I was having the same problem and hadn't seen this mentioned anywhere else. This should be flagged as the the correct answer. Giving a like. Thanks for the help.