topic Where is the error? in QlikView

Where is the error?

Sat, 08 Aug 2009 20:35:09 GMT

Hi!! I can't find where is the error in this scrip: (in DATABASE1 there is DATAWORK '01/01/2009 00:00')

Let vCurrentYear=year(today());

SQL SELECT *,

FROM $(db).dbo.DATABASE1;

Load

date(DATAWORK),

if(Year(date(DATAWORK))=Year($(vCurrentYear))-1, NUM_SALE) as NUM_SALE_2008

Resident DATABASE1;

HELP ME pls!!!!!

Thankyou very much

Where is the error?

Anonymous — Sat, 08 Aug 2009 22:57:10 GMT

Can't tell about some specifics - not enough info. But there are at least 2 issues:
1. Comma after *.
2. Variable vCurrentYear is 2009. The function Year(2009) returns 1905, because the date(2009) is July 1, 1905. If you want previous year, it should be just $(vCurrentYear)-1.
(And, the field name probably should bebetter NUM_SALES_LASTYEAR instead of NUM_SALES_2008.)