topic General Script Error in QlikView

General Script Error

Fri, 05 Mar 2010 11:53:25 GMT

I am trying to look up a calender file returning a single record with Today's date. Using this returned record I am trying to get the Financial Year & Period value and then in another table return all records from the same calendar table so I can then get the start date of the Financial Year & Period combination.

My issue is that each time I run it I get the General Script error message. Can anyone please provide me with information on what I am doing wrong.

SET dteToday= date(ReloadTime());

Calendar:
LOAD FinancialYear,
FinanceYearPeriod,
Date,
CalendarWeek,
FinancialPeriod,
FinancialPeriodWeek,
FinancialWeek,
FinancialQuarter,
Day,
FullDate,
CalenderDocCounter,
NoOfDaysInPeriod,
NoOfDaysInYear
FROM
\\206.156.1.3\QlikView\Data_QVD\Calendar.qvd (qvd)
WHERE FullDate = $(dteToday);

SET v1 = min(FinanceYearPeriod);

//get todays period details
TodayDetails:
LOAD Date as NODDate,
FullDate as nodFull,
1 as DayCounter,
FinanceYearPeriod
Resident Calendar Where FinanceYearPeriod = $(v1);

set vThisFYP = load min(FinanceYearPeriod) resident Calendar;
Set vThisPeriodStart = min(nodFull);

Many Thanks

General Script Error

Fri, 05 Mar 2010 17:58:23 GMT

So with "each time I run it" you mean a reload?

If so, then the first variable is set to now and I am not sure table Calendar will have a record with field FullDate =now ...?!?

But perhaps you meant something else?

General Script Error

disqr_rm — Fri, 05 Mar 2010 20:57:07 GMT

Try:


Calendar:
LOAD FinancialYear,
 FinanceYearPeriod,
 Date,
 CalendarWeek,
 FinancialPeriod,
 FinancialPeriodWeek,
 FinancialWeek,
 FinancialQuarter,
 Day,
 FullDate,
 CalenderDocCounter,
 NoOfDaysInPeriod,
 NoOfDaysInYear
FROM
\\206.156.1.3\QlikView\Data_QVD\Calendar.qvd (qvd)
WHERE FullDate = $(dteToday);
MinFY:
LOAD min(FinanceYearPeriod) as MinFY
RESIDENT Calendar
GROUP BY 1;
Let v1 = peek('MinFY');
DROP TABLE MinFY;
//get todays period details
TodayDetails:
LOAD Date as NODDate,
 FullDate as nodFull,
 1 as DayCounter,
 FinanceYearPeriod
Resident Calendar Where FinanceYearPeriod = $(v1);

The min() and max() functions require GROUP BY addition. The code above should run fine, or atleast give you idea.

General Script Error

wizardo — Thu, 06 Jan 2011 07:09:01 GMT

if you have only aggr expression in your load the you dont have to use the groupBy clause

qlikview will consider the entire table as one big group

kinda like using TOTAL