Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
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....
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