I'm very new to QlikView so appologies for being dumb... but I am struggling to find the best way (or any way!) of calculating figures based on current rates that are maintained in SAP.
I have the contents of table TCURR available which contains:-
RateType
FromCurr
ToCurr
DateFrom
ExchRate
P
EUR
USD
20120701
1.3234
M
EUR
USD
20120101
1.2442
And I have a main billing facts table which has many fields but an example is below:-
CompanyCode
FiscPer
ProdHierLev1
DocCurr
NetRevenue
0500
001.2012
PYT
EUR
100
0500
001.2012
PYT
GBP
200
My question is... in QlikView world how can I join this data? In BW it is all handled at query runtime by SAP, but I know that I need to somehow replicate that in QlikView but I'm unsure how.
What I need is for the users to be able to select a target currency (USD) and rate type and convert all NetRevenue values at that rate as per TCURR table.
I fixed this myself. I joined the billing facts table to the exchange rate table on DOC_CURRCY. For P rate conversions only the latest P rate is used regardless of time so I just needed to find the latest P rate for the DOC_CURRCY and the TO_CURRCY.
