Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

gaurav2017
Contributor II

How to load Fields like Customers.CompanyName ???

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.

Capture.JPG

1 Solution

Accepted Solutions
gaurav2017
Contributor II

How to load Fields like Customers.CompanyName ???

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.

2 Replies
Not applicable

How to load Fields like Customers.CompanyName ???

Try [Customers.CompanyName]

gaurav2017
Contributor II

How to load Fields like Customers.CompanyName ???

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.