If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have to different tables I want to combine and when I left join InvoiceItems table I want to multiple InvoicePrice & InvoicePriceFactor if InvoicePriceFactor exists for that InvoiceID.
Any help is appreciated!
LEFT JOIN (InvoiceItems)LOAD IF (InvoicePriceFactor <> '', InvoicePriceFactor *InvoicePrice) as InvoicePrice RESIDENT InvoiceMarginMapping;DROP TABLE InvoiceMapping;
InvoiceItems_Temp:LOADInvoiceID,InvoicePrice,InvoiceCostFrom (Your Data Source);
LEFT JOIN (InvoiceItems_Temp)LOADInvoiceID,InvoicePriceFactor,InvoiceCostFactor;From (Your Data Source);
InvoiceItems:LOADInvoiceID,InvoicePriceFactor * InvoicePrice as InvoicePrice,InvoiceCost,InvoicePriceFactor,InvoiceCostFactorResident InvoiceItems_Temp;
DROP TABLE InvoiceItems_Temp;
View solution in original post