Discussion board where members can get started with Qlik Sense.
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)LOADCategoryID,Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,DecFROM Budget (qvd);
Sales:LOADCustomerID,OrderDate,OrderID,ProductID,QTY,AMOUNT,CANCEL_FLAGFROM Sales.qvd (qvd);
Products:LOADCategoryID,ProductID,ProductName,SupplierID,"TYPE" as protypeFROM Products (qvd);
Currently your data does not have any common date dimensions to do this comparison.
You can create a month field in Sales table:
Sales:LOADCustomerID,OrderDate,Month(OrderDate) as Month,OrderID,ProductID,QTY,AMOUNT,CANCEL_FLAGFROM 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.