joining more than 1 table

manozpph — Wed, 30 Jul 2014 17:55:32 GMT

Employee Table(EmpID,EmpName,DeptID)

Customer Table(CustID,CustomerName,CustAddress,CustPhone,City)

Orders Header Table(OrdID,CustId,OrdDate,Total Sales,Total Quantity)

Time Table(Date,Month,Year,Quarter)

OrderDetailsTable(OrderId,CustId,OrderDate,ProductId,EmpId,LineNo,LineQuantity,LineAmount,InvoiceDate)

Product Table(ProductId,ProductName,CategoryName)

Questions:

1.I want by customer name,customer city and invoice year, i want line quantity,line amount where custId=5,10,15-------

I want by customer name,customer city and invoice year, i want Total Sales and total Quantity.

3.I want by Product Name by Category Name by Invoice Month,by Invoice Year I want Line Quantity and Line Amount when Line Amount >=$500

I want by Product Name by Category Name by Order Month by Order Year I want Line Quantity and Line Amount whereTotal Amount >=$500 and Last current 3 Years.

I Have a Question here how to join invoice year using time table and order Details Table....?

Guys Can you help me finding above 4 questions....

Re: joining more than 1 table

Anonymous — Thu, 31 Jul 2014 06:52:01 GMT

HI Monohara,

QlikView associates tables using columns of the same name. To force the association simple rename the column. In your case

LOAD

Date as InvoiceDate,

Month,

Year,

Quarter

from TimeTable;

Use <CTRL T> to see the resulting Table structure.

As you've got more than one date (InvoiceDate and OrderDate) you'll need to setup corresponding date dimensions - there's lots of examples of this on community - e.g. Creating A Master Calendar

topic Re: joining more than 1 table in QlikView

joining more than 1 table

Re: joining more than 1 table