"Script Error", why?

wgonzalez — Thu, 09 Aug 2012 22:15:18 GMT

Hi,

I want to summarize transactions in a resident table, but I'm getting the "Script Error" message and can't identify the cause. Could someone help? See the script below.

Thanks.

/* Summarized Attendance Data */

AttTemp:
LOAD DTPunchDate as PunchDate,
ParentTrans as ParentT,
AttCategory as AttCat,
AttHours as AttH,
Date(monthstart(DTPunchDate), 'MMM-YYYY') AS
MonthYear
Resident AttTrans
Order By DTPunchDate asc;

/* Summarizes Attendance Transactions. Used for charts showing annual info per month. */
AttSumm:
LOAD MonthYear,
ParentT as ParentTr,
AttCat as AttCateg,
sum(AttH) as AttHoursSumm
Resident AttTemp
Group By MonthYear, ParentT;
//Order By MonthYear, ParentT asc;

//DROP Table AttTemp;

Re: "Script Error", why?

swuehl — Thu, 09 Aug 2012 22:31:38 GMT

You need to either add AttCat to your group by field list or use an aggregation function with AttCat:

No other fields than the aggregation fields may be used outside aggregation functions in the loaded expressions.

Re: "Script Error", why?

wgonzalez — Fri, 10 Aug 2012 17:23:53 GMT

Thanks! It worked!

topic "Script Error", why? in QlikView

"Script Error", why?

Re: "Script Error", why?

Re: "Script Error", why?