How show different currencies if I only have my data in one

[EmmanuelAJ]

Hello everyone, 

First of all thank you for take time to read this

I'm beginner in QlikView, and I want to show values in four different currencies USD, EUR, GBP and local currency

This is the original data (Microsoft Excel), it contains only the local currency. 

Question: how could I convert the local currency in different ones? Do I have to add a exchange rate in my original data or create a new Excel document with the exchange rates only? 

I attached you my Excel file if you want to see it

#Currency #ExchangeRate

[Qlik1_User1]

Hi @EmmanuelAJ ,
You need to create a table in which local currency, other currency , exchange rate and YearMonth is present.
And use that table in your data model based on Local currency and Date (YearMonth)

[QFabian]

 Hi @EmmanuelAJ , you can create an excel like this :

and join it to your current table, then create the formulas (creating another table using resident) likes this :

Amount * USD exchange rate    as Amount USD.

[EmmanuelAJ]

Thank you, I already create the excel file

Then, I reloaded my script:

 The formula you're saying , is in the script or in the expressions?

Thanks and sorry for the inconvenience

[EmmanuelAJ]

Thank you, 

I have these 2 different files:

I reloaded the script but then I don't know how to link both tables

For example I have a plan amount in local currency but when I click y another currency it doesn't show anything:

But when I click in another currency, qlik view shows this:

that's why I'm asking again 😞 

[QFabian]

Hi, the idea is créate that new fields in your script, so you can just simply use it in your chart expressions as sum(AmountUSD) for example.

[QFabian]

No problem, the idea is always try to put the formulas in the script, so in that way you are triyng to avoid to many calculations in the user interface.

[Qlik1_User1]

Hi @EmmanuelAJ 

Create a key in both tables YearMonth (for e.g. 202010, 202011 etc) and both tables will be linked on the basis on this newly created key and will solve the purpose.

For Table1 - Year&NUM(Month) as Key
FOr Table2 - Year&Month as Key