Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
Not applicable

Working with SAP and TCURR

Hi all,
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:-
RateTypeFromCurrToCurrDateFromExchRate
PEURUSD201207011.3234
MEURUSD201201011.2442
And I have a main billing facts table which has many fields but an example is below:-
CompanyCodeFiscPerProdHierLev1DocCurrNetRevenue
0500001.2012PYTEUR100
0500001.2012PYTGBP200
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.
Any hints and tips will be very much appreciated!
Thanks in advance.
Sean.
1 Reply
Not applicable

Re: Working with SAP and TCURR

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.