topic Field not found ...... in QlikView

Field not found ......

Tue, 08 Jun 2010 23:53:49 GMT

Good Afternoon Fellows:

Im doing the example of a tutorial and i have this code:

OrdersByYear_Source:
Load
CustomerID,
OrderID,
Year

RESIDENT
Orders
WHERE
Year = 2003 OR Year =2004;

LEFT JOIN (OrdersByYear_Source) LOAD
OrderID,
NetSales
RESIDENT
Order_Details;

OrdersByYear:
Load
CustomerID,
Year,
sum(NetSales) as NetSalesByYear
RESIDENT
OrdersByYear_Source
GROUP BY
CustomerID , Year;

And there is a error, FILE NOT FOUND, does anybody knows why???

Field not found ......

tabletuner — Wed, 09 Jun 2010 02:04:17 GMT

Is this all the code you have? Then I would expect a 'table not found' error because the tables 'Orders' and 'Order_Details' have to be loaded already in memory if you use the resident statement here.

AW:Re: Field not found ......

biester — Wed, 09 Jun 2010 05:29:18 GMT

Community would be able to help better and faster if the issues would be posted more carefully. Headline of this post is "Field not found", in the post it says "File not found", and as Tjeerd (and the posted code) suggest it's most likely that the error is "Table not found"..

Wonder what the error really is...

Rgds,
Joachim

Field not found ......

Wed, 09 Jun 2010 15:54:46 GMT

I will try to explain myself better:

I have this on one tab of the script:

Orders:
buffer (stale after 7 days)
Load
CustomerID,
EmployeeID,
EmployeeID as EmployeeSales,
Freight,
OrderDate,
OrderDate as CountOrderDate,
Year(OrderDate) as Year,
Month(OrderDate) as Month,
date(monthstart(OrderDate),'MMM-YYYY') as [Rolling Month],
applymap('Quarters_Map',num(Month(OrderDate))) as Quarter,
Day(OrderDate) as Day,
OrderID,
ShipperID;
SQL SELECT * FROM PRProdBD.dbo.Orders;

Order_Details:
buffer (stale after 7 days)
SQL SELECT Discount,
OrderID,
ProductID,
ProductID as CuentaIDProducto,
Quantity,
UnitPrice,
UnitPrice*Quantity*(1-Discount) as NetSales
FROM PRProdBD.dbo."Order Details";

And in the other tab i have the code below:

OrdersByYear_Source:
Load
CustomerID,
OrderID,
Year
RESIDENT
Orders
WHERE
Year = 2003 OR Year =2004; /* only load 2 years */
LEFT JOIN (OrdersByYear_Source) LOAD
OrderID,
NetSales
RESIDENT
Order_Details;
OrdersByYear:
Load
CustomerID,
Year,
sum(NetSales) as NetSalesByYear
RESIDENT
OrdersByYear_Source
GROUP BY
CustomerID , Year;