Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shay1005
Contributor
Contributor

A join between 3 tables and one of the tables is crosstable

Hi everyone,

I have 3 tables sales products and Budget( crosstable table) 
The goal of join between 3 tables and  comparing a sales table with a budget table by products and by months (in Data load editor) ?

Attached to the table structure:

Budget:
CrossTable(Month,Budget,1)
LOAD
CategoryID,
Jan,
Feb,
Mar,
Apr,
May,
Jun,
Jul,
Aug,
Sep,
Oct,
Nov,
Dec
FROM Budget (qvd);

Sales:
LOAD
CustomerID,
OrderDate,
OrderID,
ProductID,
QTY,
AMOUNT,
CANCEL_FLAG
FROM Sales.qvd (qvd);

Products:
LOAD
CategoryID,
ProductID,
ProductName,
SupplierID,
"TYPE" as protype
FROM Products (qvd);

Thanks

1 Reply
Lisa_P
Employee
Employee

Currently your data does not have any common date dimensions to do this comparison.

You can create a month field in Sales table:

Sales:
LOAD
CustomerID,
OrderDate,
Month(OrderDate) as Month,
OrderID,
ProductID,
QTY,
AMOUNT,
CANCEL_FLAG
FROM Sales.qvd (qvd);

But you still only see your budget at Category level, so you cannot compare your product sales with your budget except at this level.