How to load Fields like Customers.CompanyName ???

gaurav2017 — Fri, 20 Nov 2020 18:02:30 GMT

Invoices:

LOAD ShipName,

ShipAddress,

ShipCity,

ShipRegion,

ShipPostalCode,

ShipCountry,

CustomerID,

Customers.CompanyName,

Salesperson,

OrderID,

OrderDate,

Year(OrderDate) as Year,

Month(OrderDate) as Month,

Week(OrderDate) as Week,

Day(OrderDate) as Day,

'Q' & Ceil((Month(Addmonths(OrderDate,-3))/3)) as Quarter,

RequiredDate,

ShippedDate,

Shippers.CompanyName,

ProductID,

UnitPrice,

Quantity,

Discount,

ExtendedPrice,

(UnitPrice*Quantity) as GrossRevenue,

((UnitPrice*Quantity) - ((UnitPrice*Quantity)*Discount)) as NetRevenue,

Freight;

SQL SELECT *

FROM `D:\Test\Session 01\Data Sources\Nwind.mdb`.Invoices;

This table is taken from the popularly available NorthWind.mdb data source.

When i try to load these kind of fields. It giives me an error.

How to load Fields like Customers.CompanyName ???

Wed, 16 May 2012 13:22:12 GMT

Try [Customers.CompanyName]

How to load Fields like Customers.CompanyName ???

gaurav2017 — Mon, 21 May 2012 09:17:26 GMT

Thanx for reply Mr. Frankcrezee.

Sorry to bother, but got the solution. I actually did a silly thing by loading even the queries with the tables. QlikView loads only tables. I tried to peek into the Database & got the answer.

topic How to load Fields like Customers.CompanyName ??? in QlikView

How to load Fields like Customers.CompanyName ???

How to load Fields like Customers.CompanyName ???

How to load Fields like Customers.CompanyName ???