If I understand what you want, you can do a left join between two tables and put the field multiplication as a new field in the sales table. Read this query again as Resident and create a new field by multiplying the desired field by field multiplication.
Hope this helps!
God Bless You!
What you can do is a left join to the table containing the multiplier or a mapping load, in order to get the multiplier into your transactions table for the calculation.
As i understood, the barcode is a key field so you can do like below:
//this table will be automatically dropped after script execution as the load is preceded by mapping
Mapping Load Distinct Barcode, Multiplier
Qty * ApplyMap('Map_Multiplier', Barcode) as CalculatedTonnage
Load Distinct Barcode,
Qty * Multiplier as CalculatedTonnage
drop table tempTransactions;
Hope this helps you!
Tried example 2, ran into a problem though.....
I get my information from several different files (2010 Q1, 2010 Q2, 2010 Q3, 2010 Q4, 2011 Q1, 2012 Q1 etc), in the table viewer it puts all the Sales data into a table called 2010 Q1, but when I put in From [2010 Q1]; it just says can't find the table in the folder where I have the Qlikview file saved.
Any help would be great.