Dear users,
I'm currently trying to match a budget with actual sales. However, I can't seem to figure out how to connect the data. In the attached file you'll find my datasource. First, I made a crosstable from the Budgetsheet (as seen in the code below). Now I would like to add another colum with the sales per ArtGroupCode per Salesman per Category, but only with the data from 2018. In the sheets InvoiceHeader and InvoiceLine, the orders are connected and specified with a date, range January 1st 2017 - March 9 2018. Any ideas on how to do this? I'm using QlikSense, pretty newbie and trying to learn 🙂 Thanks in advance!
Budget:
CrossTable(BudgetCategory, BudgetAmount, 2)
LOAD
SalesmanCode as BudgetSalesmanNo,
ArtGroupCode as BudgetArtGroupCode,
Overige,
Restaurant,
Supermarkt,
Toko
FROM [lib://***]
(ooxml, embedded labels, header is 1 lines, table is Budget);
