Hi Experts,
I am new to Qlik , and I need to convert some currencies coming from SAP BI Extractors(Cubes).
In SAP we have three tables TCURX(Non Decimal Currency) , TCURF(Factor Table), TCURR(Exchange rate table) and these are multiplied to get the desired currency.
We cannot directly multiply these records to Exchange rate and get the desired currency.
As Qlik has created these standard connectors for SAP BI, do we have something in Qlik using which we can convert the currencies directly something like Sub routine or method.
I checked currency translation as in SAP link, this may help get a simple scenario , but not with the complex scenario where TCURX(Non Decimal Currency) , TCURF(Factor Table) table are involved.
Please help.
Regards,
Abhishek Bhattacharya
