Handling Opening / Closing Balance in Qlik with different Currencies
I have a transaction table with transactions in different currencies.
Company X has the Local Currency NOK
Company Y has the Local Currency SEK
Company Z has the Local Currency EUR
What I am trying to achieve is that they can see their balance consolidated after removing eliminations in their different currencies.
So if I press that I want to see it in NOK it has to multiply (fake currencies here):
The par tof the fact table that is in NOK * 1 (Local currency)
The part of the fact table that is in SEK * 1,2 (turns this into NOK)
The part of the fact table that is in EUR / 8 (turns this into NOK)
If I wanted to see it in EURO it would be
The part of the fact table that is in NOK * 8 (Now in EURO)
The part of the fact table that is in SEK * 8,8 (Now in EURO)
The part of the fact table that is in EUR * 1 (Local Currency)
Just re-calcaulating the transaction history doesn't work here so I am trying to understand how I can do this in front-end or solve it otherwise. I have currencies daily and monthly from NOK to SEK, EUR, DKK, GBP (the currencies I want to see this in).
I'm not sure if the aggregate function of SUM would work but that's where I would start. Of course, you have to make sure you flag your transactions with the currency type they belong with. Also, NOK? Who is doing business with North Korea?!