Discussion board where members can get started with QlikView.
Can someone explain to me how to calculate a field in the script from two fields in a table that is the result of left-joining to load statements?
Here is the simplified script
Left Join Load
What is the next step to add to this table the field InvoiceValueUSD=InvoiceValueEuro*ExchangeRate ??
A simple approach would be a resident load (or store to and load from a qvd) with adding the new field:
LOAD *, InvoiceValueEuro*ExchangeRate as InvoiceValueUSD
drop table Tab1;
Or you could do a Mapping Load of your Exchangerate table first,
then use applymap function in creation of your new field while loading your value table.
Thanks a lot for both answers. I have tried both solutions, and each works fine.