9 Replies Latest reply: Mar 5, 2018 6:19 PM by Ali Ahmad RSS

    Handling Opening / Closing Balance in Qlik with different Currencies

    Ali Ahmad

      Hi,

       

      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).

       

      Hope that explains it.

       

      Best,

       

      Ali A